General Betting
There is currently 1 person viewing this thread.
I have spent ages trying to work out the calculation to work something out. Any help would be appreciated.
Here goes :-
=IF(AM7="Y",IF(AE7>50,(K7*0.5),0),0)
In the above calculation if Cell AE7 is Higher than 50 it ensures cell K7 is multilied by .5
What I need to do now is calculate the following
If cell AE7 is higher than 50 or lower than 60 (or between 50-60) to ensure cell K7 is multipied by .5
Any help would be appreciated if you could just past in the calc
Many thanks
Here goes :-
=IF(AM7="Y",IF(AE7>50,(K7*0.5),0),0)
In the above calculation if Cell AE7 is Higher than 50 it ensures cell K7 is multilied by .5
What I need to do now is calculate the following
If cell AE7 is higher than 50 or lower than 60 (or between 50-60) to ensure cell K7 is multipied by .5
Any help would be appreciated if you could just past in the calc
Many thanks
sort by:
Show
per page
Replies: 4
|
By:
Use AND
=IF(AM7="Y",IF(AND(AE7>50,AE7<60),(K7*0.5),0),0) might want to set the parameters to 49.9 and 60.1 if you need to include 50 and 60 |
|
By:
Replace
AE7>50 with AND(AE7>50,AE7<60) OR >= AND <= ACCORDING TO WHAT THE RULE is when it is exactly 50 or 60 |
|
By:
Guys. a million thanks , you can always rely on a Betfarian to get you out the **.
Much appreciated guys Thanks Again, have a great xmas |
|
By:
.
|