View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hln hln is offline
external usenet poster
 
Posts: 2
Default Set total amount for an equation.....

I have a total dollar amount I have to stay under....not go over. I am
gathering the totals from multiple cells which is a percentage from another
number. is there a way to put like a cap on the total so it only calculates
upto a certain number? Im not sure how to explain this without looking at
it.
--
Heather