CODEWITHSUNDEEP
excelif-statementexcel-formula
Nene
Nene

Reputation: 55

IF AND and IF OR in same formula

The calculation should be carried out when the following conditions are met:

The formula works when only one condition is set in Lookups!E8 as below:

=IF(AND(Lookups!B4=1,Lookups!B5=FALSE,Lookups!E8=2),100%-G50-G51,0)

But when I try to add the OR function I get a FALSE error:

=IF(AND(Lookups!B4=1,Lookups!B5=FALSE),IF(OR(Lookups!E8=2,Lookups!E8=3),100%-H50-H51,0))

I've tried nesting the OR bit too but cannot get that to work either.

Please can someone help....thank you.

Upvotes: 0

Views: 121

Answers (1)

Harun24hr
Harun24hr

Reputation: 37125

I think you do not need second if. Nest OR() function inside AND() function. Try-

=IF(AND(Lookups!B4=1,Lookups!B5=FALSE,OR(Lookups!E8=2,Lookups!E8=3)),100%-H50-H51,0)

Upvotes: 1

Related Questions