I have a simple IF calculation, however the higher/lower calculation of the formula varies so we calculate this.
How can I insert the value of a cell into an IF formula calculation
STANDARD FORMULA
=if(D2<=A2,"Lower","")
REFERENCE A CELL FORMULA
=if(D2"C2"A2,"Lower","")
So always insert the...