Try: =IF(Sheet2!L5="","",IF(Sheet2!L5-100<100,0,Sheet2!L5-100))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---
"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?