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.

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.

=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

This will show the result 9 if the D8-D4 value is less than 9 otherwise it
will result you the as per the formula D8-D4
=IF(D8-D4<9,9,D8-D4)

If you want to show the result as blank if the D8-D4 result is greater than
9 then use the below one.
=IF(D8-D4<9,9,"")

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"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.