If function excel

[cs389]

Hi I am trying to do an if function to say that if the value is less than 0 make it 0 and if its more than 0 keep it as what it is so ive typed


=IF(D52<0,0,D52)


and the original value of D52 was 0.2 so it should stay as 0.2 and excel says the function answer is 0.2 but 0 comes up in the cell!! Why?!


Thanks

carrie

 

[mrzoogle]

hi,

have you tried formatting cells as number with 2 decimal ?

Cheers,

 

[Luke M]

ditto to what mrzoogle said. Also, you could change your formula to:

=MAX(0,D52)


It's "slightly" more efficient.

 

[cs389]

Yeah its to two decimals so just gives 0.0 but ive tried the max thing and that works thanks

 

[Luke M]

Glad to hear it's working. Curious though as to why first formula wasn't...

 

[SirJB7]

Hi, cs389!

It sounds too strange for me too... Could we have an uploaded file just to check it directly?

Regards!