D
Dean Brown
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.
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.