Adding another field if the equation = True

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top