If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hide formula
We are doing a time card and have this formula: =MAX(0,37.5-M8) when we
insert the formula in the cell and theres no hours for that pay period it shows 37.5 how can we hide the formula so the cell is blank. |
#2
|
|||
|
|||
Hide formula
=IF(M8="","",MAX(0,37.5-M8)
-- Regards, Peo Sjoblom (No private emails please) "skateblade" wrote in message ... We are doing a time card and have this formula: =MAX(0,37.5-M8) when we insert the formula in the cell and theres no hours for that pay period it shows 37.5 how can we hide the formula so the cell is blank. |
#3
|
|||
|
|||
Hide formula
Thanks, but it didn't work . Again, 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? "Peo Sjoblom" wrote: =IF(M8="","",MAX(0,37.5-M8) -- Regards, Peo Sjoblom (No private emails please) "skateblade" wrote in message ... We are doing a time card and have this formula: =MAX(0,37.5-M8) when we insert the formula in the cell and theres no hours for that pay period it shows 37.5 how can we hide the formula so the cell is blank. |
#4
|
|||
|
|||
Hide formula
On Sat, 15 Oct 2005 09:51:29 -0700, "skateblade"
wrote: We are doing a time card and have this formula: =MAX(0,37.5-M8) when we insert the formula in the cell and theres no hours for that pay period it shows 37.5 how can we hide the formula so the cell is blank. See answers in your other thread. Rgds __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#5
|
|||
|
|||
Hide formula
Where are the numbers entered, the only thing that changes in this formula
when copied down is the cell reference and if M8 is blank then my formula returns a blank, thus copied down it will change to M9, M910 and so on like =IF(M9="","",MAX(0,37.5-M9) so it should work How exactly does the formula look that you copy down, of course if it is not blank it will return the MAX part, blank means empty and not space or something -- Regards, Peo Sjoblom (No private emails please) "skateblade" wrote in message ... Thanks, but it didn't work . Again, 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? "Peo Sjoblom" wrote: =IF(M8="","",MAX(0,37.5-M8) -- Regards, Peo Sjoblom (No private emails please) "skateblade" wrote in message ... We are doing a time card and have this formula: =MAX(0,37.5-M8) when we insert the formula in the cell and theres no hours for that pay period it shows 37.5 how can we hide the formula so the cell is blank. |
#6
|
|||
|
|||
Hide formula
Thanks again, The M9 cell Contains this formula: =SUM(I13:L13) and there are
nothing in the I9:L9 rage of cells and when I try your formula it returns 37.5. Ineed the cell to be blank if if the answer to the formula is 37.5 "Peo Sjoblom" wrote: Where are the numbers entered, the only thing that changes in this formula when copied down is the cell reference and if M8 is blank then my formula returns a blank, thus copied down it will change to M9, M910 and so on like =IF(M9="","",MAX(0,37.5-M9) so it should work How exactly does the formula look that you copy down, of course if it is not blank it will return the MAX part, blank means empty and not space or something -- Regards, Peo Sjoblom (No private emails please) "skateblade" wrote in message ... Thanks, but it didn't work . Again, 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? "Peo Sjoblom" wrote: =IF(M8="","",MAX(0,37.5-M8) -- Regards, Peo Sjoblom (No private emails please) "skateblade" wrote in message ... We are doing a time card and have this formula: =MAX(0,37.5-M8) when we insert the formula in the cell and theres no hours for that pay period it shows 37.5 how can we hide the formula so the cell is blank. |
#7
|
|||
|
|||
Hide formula
Ok, that should be easy to fix, the reason is that the sum formula returns 0
=IF(M9=0,"",MAX(0,37.5-M9) that would work if the values in I13:L13 never are negative otherwise use =IF(COUNTBLANK(I13:L13)=4,"",MAX(0,37.5-M9)) -- Regards, Peo Sjoblom (No private emails please) "skateblade" wrote in message news Thanks again, The M9 cell Contains this formula: =SUM(I13:L13) and there are nothing in the I9:L9 rage of cells and when I try your formula it returns 37.5. Ineed the cell to be blank if if the answer to the formula is 37.5 "Peo Sjoblom" wrote: Where are the numbers entered, the only thing that changes in this formula when copied down is the cell reference and if M8 is blank then my formula returns a blank, thus copied down it will change to M9, M910 and so on like =IF(M9="","",MAX(0,37.5-M9) so it should work How exactly does the formula look that you copy down, of course if it is not blank it will return the MAX part, blank means empty and not space or something -- Regards, Peo Sjoblom (No private emails please) "skateblade" wrote in message ... Thanks, but it didn't work . Again, 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? "Peo Sjoblom" wrote: =IF(M8="","",MAX(0,37.5-M8) -- Regards, Peo Sjoblom (No private emails please) "skateblade" wrote in message ... We are doing a time card and have this formula: =MAX(0,37.5-M8) when we insert the formula in the cell and theres no hours for that pay period it shows 37.5 how can we hide the formula so the cell is blank. |
#8
|
|||
|
|||
Hide formula
Thanks again for your time.
I tried the =IF(M9=0,"",MAX(0,37.5-M9) formula and excel tells me that ti's wrong and I should add a ) at the end of the formula. i added it and it works great now thanks. However, the colum next to it has this formula and it is now reading #VALUE! the formula in that cell is: =SUM(M9-N9+O9) how can I change it. "Peo Sjoblom" wrote: Ok, that should be easy to fix, the reason is that the sum formula returns 0 =IF(M9=0,"",MAX(0,37.5-M9) that would work if the values in I13:L13 never are negative otherwise use =IF(COUNTBLANK(I13:L13)=4,"",MAX(0,37.5-M9)) -- Regards, Peo Sjoblom (No private emails please) "skateblade" wrote in message news Thanks again, The M9 cell Contains this formula: =SUM(I13:L13) and there are nothing in the I9:L9 rage of cells and when I try your formula it returns 37.5. Ineed the cell to be blank if if the answer to the formula is 37.5 "Peo Sjoblom" wrote: Where are the numbers entered, the only thing that changes in this formula when copied down is the cell reference and if M8 is blank then my formula returns a blank, thus copied down it will change to M9, M910 and so on like =IF(M9="","",MAX(0,37.5-M9) so it should work How exactly does the formula look that you copy down, of course if it is not blank it will return the MAX part, blank means empty and not space or something -- Regards, Peo Sjoblom (No private emails please) "skateblade" wrote in message ... Thanks, but it didn't work . Again, 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? "Peo Sjoblom" wrote: =IF(M8="","",MAX(0,37.5-M8) -- Regards, Peo Sjoblom (No private emails please) "skateblade" wrote in message ... We are doing a time card and have this formula: =MAX(0,37.5-M8) when we insert the formula in the cell and theres no hours for that pay period it shows 37.5 how can we hide the formula so the cell is blank. |
#9
|
|||
|
|||
Hide formula
Try
=SUM(M9,-N9,O9) or =IF(M9=0,"",your_formula -- Regards, Peo Sjoblom (No private emails please) "skateblade" wrote in message ... Thanks again for your time. I tried the =IF(M9=0,"",MAX(0,37.5-M9) formula and excel tells me that ti's wrong and I should add a ) at the end of the formula. i added it and it works great now thanks. However, the colum next to it has this formula and it is now reading #VALUE! the formula in that cell is: =SUM(M9-N9+O9) how can I change it. "Peo Sjoblom" wrote: Ok, that should be easy to fix, the reason is that the sum formula returns 0 =IF(M9=0,"",MAX(0,37.5-M9) that would work if the values in I13:L13 never are negative otherwise use =IF(COUNTBLANK(I13:L13)=4,"",MAX(0,37.5-M9)) -- Regards, Peo Sjoblom (No private emails please) "skateblade" wrote in message news Thanks again, The M9 cell Contains this formula: =SUM(I13:L13) and there are nothing in the I9:L9 rage of cells and when I try your formula it returns 37.5. Ineed the cell to be blank if if the answer to the formula is 37.5 "Peo Sjoblom" wrote: Where are the numbers entered, the only thing that changes in this formula when copied down is the cell reference and if M8 is blank then my formula returns a blank, thus copied down it will change to M9, M910 and so on like =IF(M9="","",MAX(0,37.5-M9) so it should work How exactly does the formula look that you copy down, of course if it is not blank it will return the MAX part, blank means empty and not space or something -- Regards, Peo Sjoblom (No private emails please) "skateblade" wrote in message ... Thanks, but it didn't work . Again, 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? "Peo Sjoblom" wrote: =IF(M8="","",MAX(0,37.5-M8) -- Regards, Peo Sjoblom (No private emails please) "skateblade" wrote in message ... We are doing a time card and have this formula: =MAX(0,37.5-M8) when we insert the formula in the cell and theres no hours for that pay period it shows 37.5 how can we hide the formula so the cell is blank. |
#10
|
|||
|
|||
Hide formula
In the cell containing the formula you want to hide:-
Select Format Cells, Protection, click Hidden (leave locked ticked) Then:- Tools Protection, Protect Sheet (give a password if you want) Now the formula should be hidden |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Show Formula / Hide Formula | DejaVu | General Discussion | 5 | August 31st, 2005 03:42 PM |
Creating a check mark box | MarthaSue | Setting up and Configuration | 18 | April 28th, 2005 12:31 AM |
Named SUM Formula with relative refernce(s) | Werner Rohrmoser | Worksheet Functions | 2 | April 20th, 2005 04:56 PM |
Can I keep and hide a formula if there is no value in cell? | Ev | General Discussion | 3 | September 30th, 2004 10:15 PM |
Report Formula | Ady | Setting Up & Running Reports | 2 | June 30th, 2004 08:22 PM |