Force Excel to Subtract Before Multiplying

[BlueBayou]

The formula is =B6*1-C3. How can I input this formula to subtract the discount rate from 1 before multiplying and ensure that the formula will always reference cell C3 regardless of the formula's location in the spreadsheet?

[FDibbins]

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

tip: look at using () and $

[BlueBayou]

http://www.excelforum.com/excel-form...ml#post4262814
What is a PM? I don't quite understand.

[FDibbins]

PM = private Message

Thanks for the title change

Try this...
=B6*(1-$C$3)

the $ absolute's/locks a cell

[BlueBayou]

Thanks a bunch!

[FDibbins]

Happy to help