Thread: How to set a formula if the value is with #N/A
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Corey[_4_] Corey[_4_] is offline
external usenet poster
  
Posts: 19
Default How to set a formula if the value is with #N/A
D2=IF(C2<"#N/A",C2+B2,B2)
Assuming the Bonus values are in Column C and Salary amounts are in Column
B.
Reply With QuoteReply With Quote