Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 --- |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|