Posted to microsoft.public.excel.misc
|
|
Formula Problems
Just for fun:
=IF(OR(E3={1,2,3,5}),300/E3-(E3<3),0)
--
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
with @tiscali.co.uk
"Mike" wrote in message
...
=IF(E3=1,299),IF(E3=2,149),IF(E3=3,100),IF(E3=5,59 ,0))
This is what i have what am i doing wrong
Please help
|