Hi,

Go back an make sure your formula agrees with the one Max gave you, his
works correctly and will not return TRUE or FALSE if entered correctly.

--
Thanks,
Shane Devenshire


"CelticCharmer" wrote:

=IF(Sheet2!L5="","",MAX(Sheet2!L5-100))
How can I make this formula show 0 if under 100, but show the value above
100?
Any help would be grateful
Thank you.