| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mulitiple functions in one cell
=IF(left_to_spend=0,"",left_to_spend<0,ABS(left_t o_spend)/approved_amount)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "cgroninger" wrote in message ... I have a spreadsheet that I want to show the following things: Max approval amount Year-to-date expenses Amount left to spend Percentage overspent I need for the percentage overspent cell to stay blank if the amount left to spend is a positive amount, and I need it to calculate the percentage overspent if the amount left to spend is a negative number.... -- cgroninger |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mulitiple functions in one cell
I have a spreadsheet that I want to show the following things: Max approval amount Year-to-date expenses Amount left to spend Percentage overspent I need for the percentage overspent cell to stay blank if the amount left to spend is a positive amount, and I need it to calculate the percentage overspent if the amount left to spend is a negative number.... -- cgroninger |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down menu and validation over mulitiple sheets | Excel Worksheet Functions | |||
| How do I summarize items chosen on mulitiple worksheets | Excel Worksheet Functions | |||
| mulitiple cells in a drop down | Excel Discussion (Misc queries) | |||
| How can I get excel to print mulitiple colors in a cell? | Excel Discussion (Misc queries) | |||
| mulitiple droplist | Excel Discussion (Misc queries) | |||
Linear Mode
