excel sheet programme

[fredadkz]

hi , i have a excel sheet i need to add some more functions , does any know how to do this .

[Euler]

That question is so incredibly vague I doubt you will get many answers. You need to expand the question a lot.

[fredadkz]

I need to add a function to my sheet to be able to choose odds between 2-4. , at the moment my sheet only allows me to choos one odd not a range between .

[spreadbetting]

You just need to use the AND function

Say your current IF function is only working on set odds of 3

=IF(A1=3,TRUE,FALSE)

to get it to check a range you just incorporate the AND function like so, it will only now show as TRUE if the number is between 2 and 4

=IF(AND(A1>=2,A1<=4),TRUE,FALSE)

[PeterLe]

You cant put a range in the odds cell.
Suggest having a good read through the user guide to gain an overview as to what you can do :-
http://www.betangel.com/user-guide/micr ... 3D&mw=MzIw
Or click on the link to the right - User Guide

[fredadkz]

your the best ... but i still need help . I had this guy do the sheet for me and i can no longer contact him but this is where this is what my function has

=IF($K$73="BACK",G76,IF($K$73="LAY",I76,""))