Adding another field if the equation = True

M

Mindie

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

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.
 
Top