Please see the attached spreadsheet Ive explained on the sheet what I need but the essential problem is I need to check three cells and if and only if they have a value of true then process another three cells to see if one of them has a value of true and if they do then give a result of a string of text. Ive got the second part of my formula worked out but cant get the first part.
From the explanation given, I think this is all you need:
=IF(B3=FALSE,"",IF(D3=TRUE,"ABC",IF(D6=TRUE,"def",IF(D9=TRUE,"ghf",""))))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks