View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ashlee Ashlee is offline
external usenet poster
 
Posts: 3
Default String of functions confusion - please help

I will try to explain this the best I can.

I want to multiple a series of cells say C4:T4 by a specific percent, then
with that product I want to subtract it from the original number, so it would
be some thing like this:

100*.03= 3 then 100-3 = 97

That "97" is what I need to be replaced in each cell. I have no idea how to
do this at all. If someone could give me some guidance that would be great.
Thank you