Formula help
 

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

Formula help
 

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?

Formula help
 

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" wrote:

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?

Formula help
 

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" wrote:
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

Formula help
 

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" wrote:

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" wrote:
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

Formula help
 

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

Formula help
 

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.