Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula needed
Please advise how I can come about a formula for the following.
If (cell) N9=1,2,3 or 4 then (cell) O9=400, 500, 600, 700 1=400 2=500 3=600 4=700 Thank you in advance for your help. Audi |
#2
|
|||
|
|||
=IF(N9=1,400,IF(N9=2,500,IF(N9=3,600,IF(N9=4,700," "))))
Vaya con Dios, Chuck, CABGx3 "audi" wrote in message ... Please advise how I can come about a formula for the following. If (cell) N9=1,2,3 or 4 then (cell) O9=400, 500, 600, 700 1=400 2=500 3=600 4=700 Thank you in advance for your help. Audi |
#3
|
|||
|
|||
Try this:
=CHOOSE(N9,400,500,600,700) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "audi" wrote in message ... Please advise how I can come about a formula for the following. If (cell) N9=1,2,3 or 4 then (cell) O9=400, 500, 600, 700 1=400 2=500 3=600 4=700 Thank you in advance for your help. Audi |
#4
|
|||
|
|||
On Tue, 2 Aug 2005 15:09:03 -0700, "audi"
wrote in microsoft.public.excel.misc: Please advise how I can come about a formula for the following. If (cell) N9=1,2,3 or 4 then (cell) O9=400, 500, 600, 700 1=400 2=500 3=600 4=700 Maybe I'm missing something here, but wouldn't =(N9+3)*100 in O9 do that? -- Michael Bednarek http://mbednarek.com/ "POST NO BILLS" |
#5
|
|||
|
|||
All three of the responses give the correct results if N9 contains 1,2,3 or
4.........the difference being what result you would like returned if N9 is empty, contains another number or zero or a decimal number, or even TEXT. Vaya con Dios, Chuck, CABGx3 "audi" wrote in message ... Please advise how I can come about a formula for the following. If (cell) N9=1,2,3 or 4 then (cell) O9=400, 500, 600, 700 1=400 2=500 3=600 4=700 Thank you in advance for your help. Audi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More Help Needed with Count formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Formula needed | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |