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
