Formula help

[CelticCharmer]

=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.

 

[Max]

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]

Hiya Max
It's comming back and showing TRUE but I want the value to be shown,
anything over 100 to be shown and if under 100, 0(zero) to be shown. Is that
possible, as I am not good using excel
Jimmy

 

[Max]

It should work fine. Can you try justing copy the formula directly from my
response, then paste directly into the formula bar, say in Sheet1's A1?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik

 

[CelticCharmer]

Hiya Max,
I did copy it and the word TRUE appears in the cell and not the numbers. Am
I doing something wrong?
Jimmy

 

[Max]

Here's a quick implemented sample for you:
http://freefilehosting.net/download/41flm

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---

 

[ShaneDevenshire]

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.