Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating a calculator
I'm having a horrible time trying to create a calculator. Here's my situation:
I have numeric values in cell's 'A', 'B' & 'C' that start at row 1 through 100. I need to decrease some of the values by percentage. (eg, $100 in A1. $200 in B1 & $300 in C1. I'd like to have three cells that control the value of 'A' 'B' & 'C' individually by percentage. So, if I input 10 in cell D1 that will decrease $100 in A1. If input 5 in E1 that will decrease $200 in B1. And, if I input 10 in F1 that will decrease $300 in C1. Any guidance would be appreciated. -- Many Thanks, Mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating a calculator
=A1*(1-$D$1) etc
best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "mmacnz" wrote in message ... I'm having a horrible time trying to create a calculator. Here's my situation: I have numeric values in cell's 'A', 'B' & 'C' that start at row 1 through 100. I need to decrease some of the values by percentage. (eg, $100 in A1. $200 in B1 & $300 in C1. I'd like to have three cells that control the value of 'A' 'B' & 'C' individually by percentage. So, if I input 10 in cell D1 that will decrease $100 in A1. If input 5 in E1 that will decrease $200 in B1. And, if I input 10 in F1 that will decrease $300 in C1. Any guidance would be appreciated. -- Many Thanks, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Utility Cost calculator | Excel Discussion (Misc queries) | |||
uk tax calculator | New Users to Excel | |||
Calculator | Excel Discussion (Misc queries) | |||
calculator | Excel Discussion (Misc queries) | |||
calculator | Excel Discussion (Misc queries) |