#### mplees

##### Active Member

- Joined
- Feb 6, 2006

- Messages
- 351

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