I'm trying to combine two separate IF strings dependent on a the response in a certain cell - M (male) or F (female).
so, If(A2=F) and IF(B2<=I5,"A",IF('B2<=I6,"B",IF(B2<=I7,"C",IF(B2<='I8,"D","E")))) But If(A2=M) And IF(B2<=J5,"A",IF('B2<=J6,"B",IF(B2<=J7,"C",IF(B2<='J8,"D","E"))))
Basically, trying to figure out how to apply and combine in one string the appropriate IF statement depending on IF A2 is a Male (M) or Female (F).
Your help is greatly appreciated.
Try this…
=IF(A2="F",IF(B2<=I5,"A",IF(B2<=I6,"B",IF(B2<=I7,"C",IF(B2<=I8,"D","E")))),IF(A2="M",IF(B2<=J5,"A",IF(B2<=J6,"B",IF(B2<=J7,"C",IF(B2<=J8,"D","E")))),""))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks