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