General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
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
Show More
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
=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
Replace
AE7>50
with
AND(AE7>50,AE7<60)
OR >= AND <= ACCORDING TO WHAT THE RULE is when it is exactly 50 or 60
AE7>50
with
AND(AE7>50,AE7<60)
OR >= AND <= ACCORDING TO WHAT THE RULE is when it is exactly 50 or 60
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
Much appreciated guys
Thanks Again, have a great xmas
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539