if statement

  • Thread starter Thread starter rvik
  • Start date Start date
R

rvik

in col 2 , i have a if statement on col 1.

i want the if statement in a code. Also the no of data on col 1 could
vary. if there are blanks on col 1, i don't want a result on col 2

now after entering the data on col1, i drag the formula in the first
cell on col2 all the way down to the last. Also the formula is open to
all. I fear it may be tampered. In a code it maybe safe, right??

thanks

rvik
 
Hi rvik!

I'll try to help although your English is a little confusing.

Try:

=IF(A1="","",A1/2)

If A1 is empty or contains a formula that returns "", the cell with
the formula in will appear blank.

To protect formulas use:

Select the cells you want to allow access to
Format > Cells > Protection
Remove check from "Locked"
OK

Tools > Options > Protection > Protect Sheet
Give and confirm password
OK

But remember that protection of worksheets is easily circumvented and
should only be regarded as prevention against accidental corruption.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
news:[email protected]...
 
Back
Top