Mulitiple functions in one cell

[Bob Phillips]

=IF(left_to_spend>=0,"",left_to_spend<0,ABS(left_to_spend)/approved_amount)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[cgroninger]

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 amoun
left to spend is a positive amount, and I need it to calculate th
percentage overspent if the amount left to spend is a negativ
number...