Thread
:
I want to use if based on two cells (if... and)
View Single Post
#
3
Peo Sjoblom
Posts: n/a
=IF(AND(C1=0,C2="sub1"),lookup_formula,25)
Regards,
Peo Sjoblom
"coblad1357" wrote:
cell1 =0
cell2 = "subject"
If cell1= 0 and cell2="sub1" then use a lookup table else answer=25
Reply With Quote