| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Adding another field if the equation = True
If this equation is equal to True, How to I tell it to also add a cell from
another sheet. If this is equal to true I want it to read for example Nov 22 2004 PT =IF(B21=TRUE, TEXT(C20,"mmm dd yyyy"), TEXT(E20, "mmm yyyy")) |
|
#2
|
|||
|
|||
|
=IF(B21=TRUE, CONCATENATE(TEXT(C20,"mmm dd yyyy")," ",Sheet2!A20), TEXT(E20,
"mmm yyyy")) This assumes you are trying to smash some text onto the end of your date, with a space before that added text. "Mindie" wrote: If this equation is equal to True, How to I tell it to also add a cell from another sheet. If this is equal to true I want it to read for example Nov 22 2004 PT =IF(B21=TRUE, TEXT(C20,"mmm dd yyyy"), TEXT(E20, "mmm yyyy")) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
| Adding True False Results | Excel Worksheet Functions | |||
| Pivot Tables..I give up... | Excel Worksheet Functions | |||
| Grand Totals @ Same Place | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
