ExcelBanter - Nesting IF to correct #VALUE! Error Message

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

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

- - Nesting IF to correct #VALUE! Error Message (https://www.excelbanter.com/excel-worksheet-functions/228706-nesting-if-correct-value-error-message.html)

JennE

Nesting IF to correct #VALUE! Error Message

My current formula is:

=IF(G4F4,F4-G4,"0")

and it calculates correctly or displays a "0" if G4 is less than F4.

But I need help finding out what to add to this formula so that it displays
"RNC" if G4 equals RNC.

Please help, didn't sleep last night trying to think of the answer!

Teethless mama

Nesting IF to correct #VALUE! Error Message

=IF(G4="RNC","RNC",IF(G4F4,F4-G4,"0"))

"JennE" wrote:

My current formula is:

=IF(G4F4,F4-G4,"0")

and it calculates correctly or displays a "0" if G4 is less than F4.

But I need help finding out what to add to this formula so that it displays
"RNC" if G4 equals RNC.

Please help, didn't sleep last night trying to think of the answer!

JennE

Nesting IF to correct #VALUE! Error Message

YOU ROCK!!!

THANK YOU SO MUCH! Whew, now i can sleep :)

"Teethless mama" wrote:

=IF(G4="RNC","RNC",IF(G4F4,F4-G4,"0"))

"JennE" wrote:

My current formula is:

=IF(G4F4,F4-G4,"0")

and it calculates correctly or displays a "0" if G4 is less than F4.

But I need help finding out what to add to this formula so that it displays
"RNC" if G4 equals RNC.

Please help, didn't sleep last night trying to think of the answer!

All times are GMT +1. The time now is 03:24 AM.