Returning A Minimum Figure
=max(9,d8-d3)
if the result of your formula is less than 9, then =max() will use the 9.
You could also use:
=if(d8-d3<9,9,d8-d3)
If you find it easier to remember.
Hammer wrote:
Cell D9 =sum of Cell D8 (12.5) minus cell D3 (4) giving an answer of 8.5.
How do i get cell D9 to show a minumum of 9 if the answer falls below 9.
--
Dave Peterson
|