# excel 2013 if formula to use pick which higher List price to pick in Comm calculation

1. ## excel 2013 if formula to use pick which higher List price to pick in Comm calculation

have 2 List price , wants to calculate commission from which is higher list price,
how can I write the if formula , having hard time adding the formula

for example

B3 ----150,000.00 List price
B5 ------160,0000.00 List price
D6 --------- Commission column - to pick the list price which the higher , if both column same than pick the B3

really appreciate all the help

see attached the file  Register To Reply

2. ## Re: excel 2013 if formula to use pick which higher List price to pick in Comm calculation

Hi,

Try this:
=IF(B3=B5,B3,MAX(B3,B5))

Regards,

Edit:
Actually you dont need IF as if both prices are same, both cell contain the same value, so you can go with just:
=MAX(B3,B5)  Register To Reply

3. ## Re: excel 2013 if formula to use pick which higher List price to pick in Comm calculation

but D6 amount changed a lot if I changed the make amount 0 on A5 margin adj cell

have updated the file

A5 have Margin adj amount if I make that Margin adj 0

List Price -----357871.00 B3 cell
List Price --------357871.00 B5 cell

List Price ------- 357871.00 C6 cell

Standard D6 \$ 228,000.00
Nonstandard E6 \$ 139871.00

D6 should be total of B3 or B5 -E6 =D6

if the add amount on A5 or not

D6 amount should be if margin adj 0 Standard D6 amount should be \$218000.0
if margin adj amount 10000.00 than D6 Standard amount should be \$ 228000.00

really appreciate all the help

thanks again  Register To Reply

4. ## Re: excel 2013 if formula to use pick which higher List price to pick in Comm calculation

Hi,

If A6=0, then B3 will be same as B5 and you will just return that value in D6, and not 218000.

Are you sure you don't just want, in D6, B5-E6? Since B5 already is connected to B3 and A6.  Register To Reply