View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JennE JennE is offline
external usenet poster
 
Posts: 2
Default 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!