| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Problems
=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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Problems
Try it like this:
=IF(E3=1,299,IF(E3=2,149,IF(E3=3,100,IF(E3=5,59,0) ))) Biff "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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Problems
Mike,
=IF(E3=1,299,IF(E3=2,149,IF(E3=3,100,IF(E3=5,E3559 ,0)))) Rob "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 |
|
#4
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems with offset/average formula | Excel Worksheet Functions | |||
| Formula problems: Some numbers don't add up right. | Excel Discussion (Misc queries) | |||
| Array Formula Limits (around 2800 or so) ? Lotus DSUM has no problems with it ! | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| Am trying to make a time sheet and having problems with a formula. | Excel Worksheet Functions | |||
Linear Mode
