Formula Problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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
 
Try it like this:

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

Biff
 
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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula help 4
accepting most recent date across columns 10
if then and conditional formatting of dates 2
Help with if statement 4
sorting 1
Consolidate 1
Excel Help to copy information from one row at a time to another sheet 1
Entered data for use in formula 9

Back
Top