Hi All
I am working with this
=IF(ISNUMBER(B12),IF($B$11=1,$S$12,IF($B$11=2,$S$13,IF($B$11=3,$S$14,""))),"")
but need to add another variable where if B9="0" then the the equation references =IF(ISNUMBER(B12),IF($B$11=1,$T$12,IF($B$11=2,$T$13,IF($B$11=3,$T$14,""))),"")
Thanks for your time and thoughts
Jon
Hi,
Maybe:
=IF(AND(ISNUMBER(B12),$B$11=1),$T$12,IF(AND(ISNUMBER(B12),$B$11=2),$T$13,IF(AND(ISNUMBER(B12),$B$11=3),$T$14,"")))
Last edited by Limor_OP; 06-26-2020 at 04:09 AM.
May be:
Please Login or Register to view this content.
Quang PT
Thank you bebo021999!! This worked perfectly. Cảm ơn rāt nhiều!Originally Posted by bebo021999
May be:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks