software

Excel 2000.

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

=CEILING(IF(IF(J25lt;90000,0.062*I25,(90000-J24)*0.062)lt;0,quot;No FICA
duequot;,IF(J25lt;90000,0.062*I25,(90000-J24)*0.062)),0.002)

Donna,

See if this works for all cases....

=IF(CEILING(MAX(IF(J25lt;90000,0.062*I25,(90000-J24)*0.062),0),0.002)lt;=0,quot;No FICA
Duequot;,CEILING(IF(J25lt;90000,0.062*I25,(90000-J24)*0.062),0.002))

HTH,
Bernie
MS Excel MVPquot;donnaKquot; gt; wrote in message
...
gt; Excel 2000.
gt;
gt; This formula returns an error of #VALUE when I add the rounding, instead of
gt; the text quot;No Fica Duequot; Does anyone have any suggestions? I believe I must
gt; have the cell formatted as quot;numberquot; for when the cell returns a numerical
gt; value.
gt;
gt; =CEILING(IF(IF(J25lt;90000,0.062*I25,(90000-J24)*0.062)lt;0,quot;No FICA
gt; duequot;,IF(J25lt;90000,0.062*I25,(90000-J24)*0.062)),0.002)
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(J25lt;90000,CEILING(0.062*I25,0.002),IF((90000-J24)*0.062lt;0,quot;No FICA
duequot;,CEILING((90000-J24)*0.062,0.002)))--

Regards,

Peo Sjoblom

quot;donnaKquot; gt; wrote in message
...
gt; Excel 2000.
gt;
gt; This formula returns an error of #VALUE when I add the rounding, instead
of
gt; the text quot;No Fica Duequot; Does anyone have any suggestions? I believe I
must
gt; have the cell formatted as quot;numberquot; for when the cell returns a numerical
gt; value.
gt;
gt; =CEILING(IF(IF(J25lt;90000,0.062*I25,(90000-J24)*0.062)lt;0,quot;No FICA
gt; duequot;,IF(J25lt;90000,0.062*I25,(90000-J24)*0.062)),0.002)
Hi,

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

=IF(IF(J25lt;90000,CEILING(0.062*I25,0.002),(90000-J24)*0.062)lt;0,quot;No FICA
duequot;,IF(J25lt;90000,CEILING(0.062*I25,0.002),CEILING ((90000-J24)*0.062,0.002)))

Regards,
B. R. Ramachandranquot;donnaKquot; wrote:

gt; Excel 2000.
gt;
gt; This formula returns an error of #VALUE when I add the rounding, instead of
gt; the text quot;No Fica Duequot; Does anyone have any suggestions? I believe I must
gt; have the cell formatted as quot;numberquot; for when the cell returns a numerical
gt; value.
gt;
gt; =CEILING(IF(IF(J25lt;90000,0.062*I25,(90000-J24)*0.062)lt;0,quot;No FICA
gt; duequot;,IF(J25lt;90000,0.062*I25,(90000-J24)*0.062)),0.002)

Yes Peo, that works. Thanks alot

quot;Peo Sjoblomquot; wrote:

gt; You need to use CEILING within the IF formula (multiple times I guess)
gt; or else you'll get the error, maybe you can use
gt;
gt; =IF(J25lt;90000,CEILING(0.062*I25,0.002),IF((90000-J24)*0.062lt;0,quot;No FICA
gt; duequot;,CEILING((90000-J24)*0.062,0.002)))
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; quot;donnaKquot; gt; wrote in message
gt; ...
gt; gt; Excel 2000.
gt; gt;
gt; gt; This formula returns an error of #VALUE when I add the rounding, instead
gt; of
gt; gt; the text quot;No Fica Duequot; Does anyone have any suggestions? I believe I
gt; must
gt; gt; have the cell formatted as quot;numberquot; for when the cell returns a numerical
gt; gt; value.
gt; gt;
gt; gt; =CEILING(IF(IF(J25lt;90000,0.062*I25,(90000-J24)*0.062)lt;0,quot;No FICA
gt; gt; duequot;,IF(J25lt;90000,0.062*I25,(90000-J24)*0.062)),0.002)
gt;
gt;
gt;