Hi Dean,
Here is the solution:
1. & 2. Just use this formula
Excel 2007 or Excel 2010
=IFERROR((I55/I54)*3600," ")
Excel 2003 or older
=IF(ISERROR((I55/I54))," ",(I55/I54)*3600)
3. In cell A10, use the formula below(any version of excel):
=If(A9<=0.5,2,If(A9<=0.8,3,If(A9>=0.8,4,3)))
4. Watch and then do the steps below:
i. Press Ctrl+A to select all cells.
ii. Right click and choose "Format Cells".
iii. Go to Protection Tab and select "Locked" - Click Ok.
iv. Now go to those cells which needs to be unlocked(allow to enter
data) -
repeat the steps above and uncheck the "Locked".
v. In case of 2007/2010
Review --> Protect Sheet
v. In case of Office XP/2003
Tools --> Protection --> Protect Sheet
vi. and give password --> that's it :)
Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com
On Oct 22, 2:49 pm, Dean Brown <bramfiel...@googlemail.com> wrote:
> Hi group.
>
> I am very inexperienced in using MS Excel however I am trying to
> develop a simple spreadsheet which will do a calculation that I have
> to do on a regular basis. I have several questions which I hope that
> the people within this group can kindly help me with.
>
> Ok, here goes.
>
> 1 - I want a cell to contain the calculation (I55*3600)/I54 is the
> syntax simply =(I55*3600)/I54 I've currently got the
> formula =SUM(I55*3600)/I54 in this cell. I have believe that this
> formula is incorrect.
>
> 2 - The cell where the above formula is located contains the message
> #DIV/O! until a value is input into another
> cell. How can I stop this error message from being displayed?
>
> 3 - I want cell A10 to look at cell A9. The value of cell A10 will
> vary depending on what value is in cell A9.
> Basically I want a formula in cell A10 which says: If A9 is less
> than or equal to .5 then A10 = 2 but if A9 is
> greater than .5 but less than or equal to .8 then A10 = 3 or if
> A9 is greater than .8 then A10 = 4
>
> 4 - I want the operator of the spreadsheet to be able to input
> information into some cells but not be allowed to
> alter the data in other cells. How can I protect cells to prevent
> the user of the spreadsheet from altering their
> content?
>
> Hope someone can help me out within the group.
>
> TIA.
>
> Dean.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
