Perform calculation using variable percentage based on other cell value

Sir 6StringJazzer,

You have been a big help and a wonderful blessing, thank you very much!

Respects,

Francis

Originally Posted by 6StringJazzer

Here is the revised formula

=MAX(200000,MAX(200000,(1+0.04+IF(W6="New",0.06,IF(W6="Same",0.03,0)))*D6)*IF(MAX(200000,(1+0.04+IF(W6="New",0.06,IF(W6="Same",0.03,0)))*D6)>1.5*$R6,0.5,1))

It simply takes the higher of 200,000 or the final result.