Round/Ceiling on an IF function returning numerical value or text

[Guest]

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)

 

[Bernie Deitrick]

Donna,

See if this works for all cases....

=IF(CEILING(MAX(IF(J25<90000,0.062*I25,(90000-J24)*0.062),0),0.002)<=0,"No FICA
Due",CEILING(IF(J25<90000,0.062*I25,(90000-J24)*0.062),0.002))

HTH,
Bernie
MS Excel MVP

 

[Peo Sjoblom]

You need to use CEILING within the IF formula (multiple times I guess)
or else you'll get the error, maybe you can use

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

 

[Guest]

Hi,

Embed the CEILNG function at each calculation point in your formula. When
'No Fica due" is to be answer, your formula is trying to calculate
=CEILING("No Fica due", 0.002) and returns an error message. Try the
following formula:

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

Regards,
B. R. Ramachandran

 

[Guest]

Yes Peo, that works. Thanks alot

You need to use CEILING within the IF formula (multiple times I guess)
or else you'll get the error, maybe you can use

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


--

Regards,

Peo Sjoblom