Modify If formula to return N/A if value is Negatitve value

[SVTF]

Looking to modify the below formula.

If the value of the formula = negative number return a value of 0

Please Login or Register  to view this content.

[FDibbins]

If you want neg either way to show NA, then perhaps this...
=IF(and(I2="",B2=""),"NA",MAX($B$2,I2)-MIN($B$2,I2))

[SVTF]

Thanks but the above changed the value from -54 to positive 54

[FDibbins]

OK well you have 2 numbers and your formula is swapping them around. Which way round do you wantthe formula to calc?

[SVTF]

Hmm .. I am going crazy.

[martindwilson]

that still gives 0 for b2=i2

[SVTF]

I think I am on crack tonight. Been trying to get this sheet to work for way to long.

[martindwilson]

another try
=IF(I2="",IF(B2="","NA",IF($B$2-B2<=0,"na",$B$2-B2)),IF(I2-B2<=0,"na",I2-B2))

[SVTF]

This formula ... works as needed

=IF(I2="",IF(B2="","NA",$B$2-B2),I2-B2)

What I an looking to do is if the result is negative - return 0

[FDibbins]

If which 1 returns negative? Because depending on the outcome of the IF's, either 1 could be negative

[SVTF]

The I2-B2 If statement.

[martindwilson]

put max around it
max(i2-b2,0)

[SVTF]

@martindwilson - seems to be working as needed ... stay tuned for rep.