| 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 | |||
Linear Mode
