Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" wrote in message ... 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" wrote in message ... 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif function for instances of text string contained | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
Adding text before a function | Excel Worksheet Functions | |||
returning a text cell based on a number cell | Excel Worksheet Functions |