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
can someone please help with if formula
really appreciate all the help
see attached the file
thanks in advance
Bookmarks