Mulitiple functions in one cell

  • Thread starter Thread starter Bob Phillips
  • Start date Start date
B

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)
 
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...
 
Back
Top