Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals Nesting Error - Totals Above | Excel Worksheet Functions | |||
IF condition Nesting limit error | New Users to Excel | |||
IF condition Nesting limit error | New Users to Excel | |||
IF condition Nesting limit error | New Users to Excel | |||
#VALUE! error nesting IF function | Excel Discussion (Misc queries) |