View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cgroninger[_2_] cgroninger[_2_] is offline
external usenet poster
 
Posts: 1
Default 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