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

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