Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel formula
If cell M6 is less than 37.5 then calculate the difference.
|
#2
|
|||
|
|||
On Fri, 14 Oct 2005 09:52:17 -0700, "skateblade"
wrote: If cell M6 is less than 37.5 then calculate the difference. And if it isn't???? __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#3
|
|||
|
|||
=(37.5-M6)*(M6<37.5)
will retrun zero of condition is FALSE Regards, Peo Sjoblom "skateblade" wrote in message ... If cell M6 is less than 37.5 then calculate the difference. |
#4
|
|||
|
|||
Peo Sjoblom wrote...
=(37.5-M6)*(M6<37.5) will retrun zero of condition is FALSE .... OK, but why not =MAX(0,37.5-M6) ? |
#5
|
|||
|
|||
And if it isn't then leave blank "Richard Buttrey" wrote: On Fri, 14 Oct 2005 09:52:17 -0700, "skateblade" wrote: If cell M6 is less than 37.5 then calculate the difference. And if it isn't???? __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#6
|
|||
|
|||
Thanks, Both formulas worked but when we copy the cell down the sheet if the
others cells are blank, then the 37.5 apears until numbers are entered. Can the formula be "hidden" so cell is blank? "Harlan Grove" wrote: Peo Sjoblom wrote... =(37.5-M6)*(M6<37.5) will retrun zero of condition is FALSE .... OK, but why not =MAX(0,37.5-M6) ? |
#7
|
|||
|
|||
Difference between what?
Between 37.5 and current value? =IF(M6<37.5, 37.5-M6, "not less") Gord Dibben Excel MVP On Fri, 14 Oct 2005 09:52:17 -0700, "skateblade" wrote: If cell M6 is less than 37.5 then calculate the difference. |
#8
|
|||
|
|||
On Fri, 14 Oct 2005 11:09:01 -0700, "skateblade"
wrote: And if it isn't then leave blank "Richard Buttrey" wrote: On Fri, 14 Oct 2005 09:52:17 -0700, "skateblade" wrote: If cell M6 is less than 37.5 then calculate the difference. And if it isn't???? =if(M6<37.5,M6-37.5,"") Rgds __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#9
|
|||
|
|||
"skateblade" wrote...
Thanks, Both formulas worked but when we copy the cell down the sheet if the others cells are blank, then the 37.5 apears until numbers are entered. Can the formula be "hidden" so cell is blank? .... =IF(ISNUMBER(M6),MAX(0,37.5-M6),"") |
#10
|
|||
|
|||
Thank You, It didn't work. Is there a way of the cell can be blank when the
cell shows 37.5 "Richard Buttrey" wrote: On Fri, 14 Oct 2005 11:09:01 -0700, "skateblade" wrote: And if it isn't then leave blank "Richard Buttrey" wrote: On Fri, 14 Oct 2005 09:52:17 -0700, "skateblade" wrote: If cell M6 is less than 37.5 then calculate the difference. And if it isn't???? =if(M6<37.5,M6-37.5,"") Rgds __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does Excel show a formula in ONE cell ? | Excel Discussion (Misc queries) | |||
Excel CHALLENGE...3 questions(indirect,rank,array formula)... | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |