Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I return different values in single cell?
This is the general idea of what I need to do;
A1 = "A" if B1 0 BUT A1 = "B" if B1 0, AND B2 = "YES" Any help please!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I return different values in single cell?
=IF(AND(B10,B2="YES"),"B",IF(B10,"A",""))
If B1 is always 0 then =IF(AND(B10,B2="YES"),"B,"A") "Zild" wrote: This is the general idea of what I need to do; A1 = "A" if B1 0 BUT A1 = "B" if B1 0, AND B2 = "YES" Any help please!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I return different values in single cell?
=IF(B10,IF(B2="YES","B","A"),"answer undefined")
-- David Biddulph "Zild" wrote in message ... This is the general idea of what I need to do; A1 = "A" if B1 0 BUT A1 = "B" if B1 0, AND B2 = "YES" Any help please!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I return different values in single cell?
Thank you very much for your help Toppers, that worked just fine!
"Toppers" wrote: =IF(AND(B10,B2="YES"),"B",IF(B10,"A","")) If B1 is always 0 then =IF(AND(B10,B2="YES"),"B,"A") "Zild" wrote: This is the general idea of what I need to do; A1 = "A" if B1 0 BUT A1 = "B" if B1 0, AND B2 = "YES" Any help please!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Unique Consecutive Duplicate Values across Single Row | Excel Worksheet Functions | |||
Return Unique Duplicate Numeric Values across Single Row | Excel Worksheet Functions | |||
Return Numeric Labels that have Values =4 across Single Row | Excel Worksheet Functions | |||
Search multiple values to return single values | Excel Worksheet Functions | |||
Return Single Instance of Numeric Values from a Column | Excel Worksheet Functions |