Hi,
I have three cells:
G5 - can contain True or false
G6 - contains text but the if is on the basis of this cell being "Hand Delivered" or not
I have tried the following to illustrate what I after:
It speaks for itself but my formula is rubbish!:Please Login or Register to view this content.
IF G5=FALSE,"Letter Not Required"
IF G5=TRUE AND G6="Hand Delivered Letter) then show "Letter Delivered"
IF G5=TRUE,"Letter Required"
There should be no else so blank will do.
Hope someone can help. Thank you in advance.
Bookmarks