metmanners
Technical User
- Mar 10, 2008
- 24
In cell M5 I have the following formula:
=IF(K5>L5,K5,L5)
The formula should enter the value from K5 into cell M5 if K5 is greater than L5.
If K5 is less than L5, the formula should enter the value from L5 into M5.
I have set up an example in the worksheet so that the value in K5 is 7 and the value in L5 is 9.5.
The formula returns 7 into cell M5 which is wrong because 9.5>7.
Any ideas?
metman