Returning A Minimum Figure
Try this and see if it does what you are looking for.
=IF(D8-D3<=9,9,D8-D3)
Hope it helps,
Frank
"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.
|