Help needed for inexperienced MS Excel 2003 user

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.
 
J

Jim Cone

1. =IF(ISNUMBER(I54),I55*3600/I54,"")
2. See above
3. Use comparison operators in your formula...
greater than: >
less than: <
greater than or equal to: =>
less than or equal to: =<
4. All cells are "locked" in a new sheet. When/if the worksheet is "protected" then no changes can be made to the cells.
Unlock individual cells before worksheet protection is applied to allow changes to those cells.
The worksheet protection option is available from the menu/ribbon.
Cell locking/unlocking is most easily available by right-clicking the selected cells and choosing "Format Cells".
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html
(analysis of excel sorting add-in)

..
..
..

"Dean Brown" <[email protected]>
wrote in message
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.
 
J

joeu2004

1 - I want a cell to contain the calculation (I55*3600)/I54
is the syntax simply =(I55*3600)/I54 [....]
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?
=IF(I54="","",I55*3600/I54)

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 orif
A9 is greater than .8 then A10 = 4

In A10:

=IF(A9="","",IF(A9<=0.5,2,IF(A9<=.8,3,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?

Difficult to provide specific instructions without knowing your Excel
version. Search Excel Help for "protection".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top