ExcelBanter - Adding another field if the equation = True

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Adding another field if the equation = True (https://www.excelbanter.com/excel-discussion-misc-queries/16461-adding-another-field-if-equation-%3D-true.html)

Mindie

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"))

Jonathan Cooper

=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"))

All times are GMT +1. The time now is 07:31 PM.