+ Reply to Thread
Results 1 to 5 of 5

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

  1. #1
    donnaK
    Guest

    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)

  2. #2
    Bernie Deitrick
    Guest

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

    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


    "donnaK" <[email protected]> wrote in message
    news:[email protected]...
    > 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)




  3. #3
    Peo Sjoblom
    Guest

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

    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

    "donnaK" <[email protected]> wrote in message
    news:[email protected]...
    > 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)




  4. #4
    B. R.Ramachandran
    Guest

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

    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


    "donnaK" wrote:

    > 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)


  5. #5
    donnaK
    Guest

    Re: Round/Ceiling on an IF function returning numerical value or t

    Yes Peo, that works. Thanks alot

    "Peo Sjoblom" wrote:

    > 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
    >
    > "donnaK" <[email protected]> wrote in message
    > news:[email protected]...
    > > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1