mplees
Active Member
- Joined
- Feb 6, 2006
- Messages
- 351
Hi,
Wonder if anyone can help me with this. I need a formula who's result comes from evaluating another cell.
The evaluated data will be in column F, the result in column M. What I need to evaluate is as follows:
If F1=1,2,3, 8 or 10 then 0
If F1=7 then 25
If F1=4 or 9 then 50
If F1=5 then 75
if F1=6 then 100
can anyone steer me in the right direction?
Regards,
Mark
Wonder if anyone can help me with this. I need a formula who's result comes from evaluating another cell.
The evaluated data will be in column F, the result in column M. What I need to evaluate is as follows:
If F1=1,2,3, 8 or 10 then 0
If F1=7 then 25
If F1=4 or 9 then 50
If F1=5 then 75
if F1=6 then 100
can anyone steer me in the right direction?
Regards,
Mark