View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lorne Lorne is offline
external usenet poster
 
Posts: 10
Default percent of a fixed and variable number

here is my problem, I have three cells a1,b1,c1. a1: fixed, b1: variable, c1:
total of both as a %. I need to find the total precent the B1 maybe either
(+) or a (-) number. if over 100% to indicate it as "100%", if between 100%
and 0% to indicate it as is, and if under 0% to indicate it as a "0%". I am
not even sure if its possibe.