Nested If Formula which includes IF(And

**lottidotti** · 10-24-2012, 12:45 PM

I can't seem to get this formula to work. Any help would be greatly appreciated!

Please Login or Register  to view this content.

In words, I'd like to say:
If $B8 is blank then leave this cell blank.
If 5886+Formulas!$E8 is greater than 5895 then put "No Data" in the cell.

If 5886 + Formulas!$E8 is less than or equal to 5895 AND RCHGetElement($B8,5886+Formulas!$E8=0) then the cell should equal "negative 0.001"

If 5886 + Formulas!$E8 is is less than or equal to 5895 AND RCHGetElement($B8,5886<>0) then the cell should equal RCHGetElement($B8,5886+Formulas!$E8)

**tigeravatar** · 10-24-2012, 12:57 PM

lottidotti,

Perhaps...

Please Login or Register  to view this content.

**lottidotti** · 10-24-2012, 01:13 PM

Tigeravatar, thanks for the quick response.
I tried your formula, but for some reason the cell says "#NAME?"

**tigeravatar** · 10-24-2012, 01:15 PM

Probably because RCHGetElement isn't a native excel function. Do you have the UDF code or install an add-in in order to use that function?

**lottidotti** · 10-24-2012, 01:24 PM

Tigeravatar, Yes, I have the add-in.
That wasn't the problem.
Also, your formula wasn't the problem either.

I just realized that the function is:
RCHGetElementNumber (not RCHGetElement)

I am totally humbled and impressed by your skills!
Thanks for the help!