Hi everyone,
I'm new on this forum and seeking some tips and advice please.
I need to apply a formula to compare 2 values in separate columns and use the cheaper one to then apply a markup % to return the sale value.

Example.JPG

Column G Column H Column S Column U
Normal Cost Special Cost Normal Sell Price Special Sell Price

$349 $317 =+CEILING($G10/(1-$S$2),1) I need to compare Clmn G against Clmn H and use the smaller of the 2 to then apply my normal formula (=+CEILING($G10/(1-$S$2),1)


Can anyone help me please?

Thank you