Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statement
I want to write an if statement that says if cell A1 equals either "1" or "?"
then cell C2 equals cell B2. How do I create that if statement? Thanks for your help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statement
Hi Liz
in cell C2 =IF(OR(A1=1,A1="?"),B2,"") -- Regards Roger Govier "Liz J" wrote in message ... I want to write an if statement that says if cell A1 equals either "1" or "?" then cell C2 equals cell B2. How do I create that if statement? Thanks for your help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statement
Enter this in C2
=IF(OR(A1=1,A1="?"),B2,"") "Liz J" wrote: I want to write an if statement that says if cell A1 equals either "1" or "?" then cell C2 equals cell B2. How do I create that if statement? Thanks for your help! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statement
And what should C2 equal otherwise?
=IF(OR(A1="1",A1="?"),B2,"???????") Liz J wrote: I want to write an if statement that says if cell A1 equals either "1" or "?" then cell C2 equals cell B2. How do I create that if statement? Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
If statement or lookup statement not sure | Excel Worksheet Functions | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions |