Forum Discussion
Cesar Mauricio Calderon Alipi
Nov 08, 2017Copper Contributor
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??
3 Replies
- SergeiBaklanDiamond Contributor
=A/MAX(C,D)
- Cesar Mauricio Calderon AlipiCopper Contributor
THANK YOU VERY MUCH
- SergeiBaklanDiamond Contributor
You are welcome