Formula Problems

[Mike]

=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

 

[Biff]

Try it like this:

=IF(E3=1,299,IF(E3=2,149,IF(E3=3,100,IF(E3=5,59,0))))

Biff

 

[Rob]

Mike,

=IF(E3=1,299,IF(E3=2,149,IF(E3=3,100,IF(E3=5,E3559,0))))

Rob

 

[Sandy Mann]

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

[email protected]
[email protected] with @tiscali.co.uk