S shawn Sep 29, 2009 #1 In Colum A I have prices.. In column B I'd like to show the price in column A minus a 20% discount.. I can't figure it out..
In Colum A I have prices.. In column B I'd like to show the price in column A minus a 20% discount.. I can't figure it out..
B Bernie Deitrick Sep 29, 2009 #2 In B2 =A2*.8 or enter .2 into cell B1, and use =A2*(1-$B$1) HTH, Bernie MS Excel MVP
S shawn Sep 29, 2009 #3 Thanks! I think I might have tried something like that, but was putting in the wrong number.. I get it now.
Thanks! I think I might have tried something like that, but was putting in the wrong number.. I get it now.
