Min and Max

[Mcls2020]

Hi all,

Is there a way to use this formula =MAX(C3,D3)-MIN(C3,D3) with an IF statement? I would like the cell to return to 0 if there is nothing in cell D3.

Thank you.

 

[bebo021999]

You can use:
=IF(D3="",0,MAX(C3,D3)-MIN(C3,D3))
Or even
=ABS(C3-D3)

 

[Mcls2020]

Thank

You can use:
=IF(D3="",0,MAX(C3,D3)-MIN(C3,D3))
Or even
=ABS(C3-D3)

Thank you, works a treat.