Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I set a formula if A1 is "a" then C1 is 3?
I'm wanting to set a formula so that if cell A1 is "a" then C1 would be 3 and
if A1 is "b" then C1 would be 5. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I set a formula if A1 is "a" then C1 is 3?
=IF(A1="a",3,IF(A1="b",5,"Whatever you want if neither are true"))
"Karen" wrote: I'm wanting to set a formula so that if cell A1 is "a" then C1 would be 3 and if A1 is "b" then C1 would be 5. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I set a formula if A1 is "a" then C1 is 3?
Put this in C1:
=IF(A1="a",3,IF(A1="b","5","")) In article , "Karen" wrote: I'm wanting to set a formula so that if cell A1 is "a" then C1 would be 3 and if A1 is "b" then C1 would be 5. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I set a formula if A1 is "a" then C1 is 3?
Karen Wrote: I'm wanting to set a formula so that if cell A1 is "a" then C1 would be 3 and if A1 is "b" then C1 would be 5. Enter this formula in Cell C1: =IF(A1=\"A\",3,IF(A1=\"B\",5,\"\")) NOTE: for any other entry in Cell A1, Cell C1 will be blank. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=492188 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I set a formula if A1 is "a" then C1 is 3?
Thank you so much!!
"Search33" wrote: =IF(A1="a",3,IF(A1="b",5,"Whatever you want if neither are true")) "Karen" wrote: I'm wanting to set a formula so that if cell A1 is "a" then C1 would be 3 and if A1 is "b" then C1 would be 5. |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I set a formula if A1 is "a" then C1 is 3?
To return a zero when criteria is not met, try:
=(A1="A")*3+(A1="B")*5 -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Karen" wrote in message ... I'm wanting to set a formula so that if cell A1 is "a" then C1 would be 3 and if A1 is "b" then C1 would be 5. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions |