ExcelBanter - I want to use if based on two cells (if... and)

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I want to use if based on two cells (if... and) (https://www.excelbanter.com/excel-worksheet-functions/31973-i-want-use-if-based-two-cells-if.html)

coblad1357

I want to use if based on two cells (if... and)

cell1 =0
cell2 = "subject"

If cell1= 0 and cell2="sub1" then use a lookup table else answer=25

try
=if(and(cell1=0,cell2="sub1"), lookup,25)

"coblad1357" wrote:

cell1 =0
cell2 = "subject"

If cell1= 0 and cell2="sub1" then use a lookup table else answer=25

Peo Sjoblom

=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

All times are GMT +1. The time now is 12:04 PM.