Thread: Round/Ceiling on an IF function returning numerical value or text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
donnaK
 
Posts: n/a
Default Round/Ceiling on an IF function returning numerical value or text
Excel 2000.

This formula returns an error of #VALUE when I add the rounding, instead of
the text "No Fica Due" Does anyone have any suggestions? I believe I must
have the cell formatted as "number" for when the cell returns a numerical
value.

=CEILING(IF(IF(J25<90000,0.062*I25,(90000-J24)*0.062)<0,"No FICA
due",IF(J25<90000,0.062*I25,(90000-J24)*0.062)),0.002)
Reply With QuoteReply With Quote