Forum Discussion

whitemetal2100's avatar
whitemetal2100
Copper Contributor
Mar 01, 2019
Solved

strugling with a nested formula

I am trying to create an auto error message to flag up an incomplete entry. The formula I've written seems logical to me but  Excel wont accept it and gives me an error message.   =IF(OR(Part1!B5>0...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Mar 01, 2019

    Nested IF looks like

    =IF(Cond1, IF(Cond2, A, B), C)

    Your formula is

    =IF(Cond1), IF(Cond2), A, B, C

    Other words, that's not a formula at all.

     

Twifoo's avatar
Twifoo
Silver Contributor
Mar 01, 2019
Perhaps, this formula returns your desired result:
=IF(AND(Part1!B5>0,Part1!B6>0,Part1!J19>0),
Part1!B5,
"ERROR")
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 02, 2019

    As I understood the logic is

    if <at least one entered> then
   if <all entered> then B5
   else "ERROR"
else <empty string>

    which is directly translated into nested IF