1

I am trying to nest formulas and cant seem to resolve my issue with solutions from other postings. I would like my formula to search a cell and if blank, return a blank...if the referenced cell has a number, return an "iferror" result

For example in the below I would like cell "W2" to return a blank as "S2" is blank. If "S2" were to have any numeric value, it would populate the calculated variance in "W2" (i.e. =IFERROR((P51-P50)/P50,0))

Thanks so much in advance!

1

1 Answer 1

0

Try this:

=ifs( 
  isblank(S2), iferror(1/0), 
  isnumber(S2), iferror( (P51-P50) / P50, 0 ), 
  true, na() 
)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.