Forum Discussion

Cesar Mauricio Calderon Alipi's avatar
Nov 08, 2017

Help with an excel division formula

Alright, so I am building this formula sheet and I have the following problem.

 

These are my variables:

A

B

C

D

 

most of my formulas are very easy like A/B or C/D, but in my third needed formula i would have to divide 

 

A/ C or D, depending on which one has a higher value, in other words, if C is >D, my formula would be A/C and A/D if D is >C.

 

Is there an easy way to do this??

 

Resources