Excel 2013 already have Target GM % , wanst to add Target Sales Price

have this spreadsheet , already have Target GM % cell, calculation, now wants to add Target Sales Price

have attached the file

Cell I10 have formula, if I change the GM % on J10 it will Calculates the Price as per GM %

now wants to add Target Sales Price to it

if the users wants to add the Target price in cell L10 an it calculate like other cell D10,E10,F10,G10 change, GM% on M10 correct

is there any if formula , that can be added if GM% J10 cell changes or L10 Target Sales Price change,
all the other calculation like comm and Gross margin can change also.


I am not sure if this is possible on same row

I know you guys are genius ,

please advise

thanks in advance
if its not possible, please advise that also, what's the best solution ?

thanks again

Attachment 395017
This isn't pretty, but it works. I made it so if anything is entered into target price, the other cells will all be based off the target price. When the target price is empty, then the other cells will be based off the target GM.

thanks al lot nigelbloomy

you are genius

it worked, I was not sure , if it will work,

thanks again

thanks FDibbins

for all the reply, I will try without sum also.

you guys are just great .