Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple IF statement
Hi All,
I need to get a formula which says if there is any value in a2, then make a1 = "Accepted" Im sure I need an If statement, but not sure how I do the "any value" bit. Appologies I am a noob to this. Many Thanks Steve |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple IF statement
Try this in A1
=IF(A2<"","Accepted","") Mike "Steve Douglas P2p, MCP" wrote: Hi All, I need to get a formula which says if there is any value in a2, then make a1 = "Accepted" Im sure I need an If statement, but not sure how I do the "any value" bit. Appologies I am a noob to this. Many Thanks Steve |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple IF statement
=IF(A2<"","Accepted","")
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Steve Douglas P2p, MCP" wrote in message ups.com... Hi All, I need to get a formula which says if there is any value in a2, then make a1 = "Accepted" Im sure I need an If statement, but not sure how I do the "any value" bit. Appologies I am a noob to this. Many Thanks Steve |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple IF statement
=IF(A2<"","Accepted","")
-- David Biddulph "Steve Douglas P2p, MCP" wrote in message ups.com... Hi All, I need to get a formula which says if there is any value in a2, then make a1 = "Accepted" Im sure I need an If statement, but not sure how I do the "any value" bit. Appologies I am a noob to this. Many Thanks Steve |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple IF statement
Thanks all, very kind for your answers.
Kind Regards Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple IF statement | Excel Worksheet Functions | |||
Simple IF statement | Excel Worksheet Functions | |||
Simple IF statement | Excel Worksheet Functions | |||
Simple If Statement | Excel Worksheet Functions | |||
Simple IF statement (hopefully!!) | Excel Discussion (Misc queries) |