Nested "If" Clauses

simple way:

write the same if-clause in all four cells (use b$11 and you can copy the formula)

But this may be a misinterpetation of your problem? You want to exame the content in b11 and if 0.001 then "overwrite" the content of b17,b19..?

If yes then still simple - put your "original" value in a adjacant collumn (e.g. A)

then in the B collumn have this if clause:

=iif(b$11=.0001;0.0001;a17)
and copy this to then rest

all other cell must just have a =aXX formula

Best regards

Morten

Are B17, B19, and B21 user inputs or calculated?

If they are user inputs, you need to use the Data>Validation tool to restrict the input. SHould be straightforward.

If they are computed, you can use =MAX(your formula here, 0.0001). If the formula value is zero, 0.0001 would be used.

To automatically place the value 0.0001 into 3 cells that are normally user inputs, you would have to write a VB macro that would run every time the user changes the value in b11. You can do this, but there may be a better way, as others have suggested.

Can you give a little more information?

You say that you require cells to equal 0.0001 to stop another formula trying to divide by 0. Why not in the end formula (where divide by 0 occurs), you put an IF statement such as "=if(B11=0,"",xxxxxxxxxxxx)

where al the "x" are, put your orginal formula in. the "" represents a blank cell.

You may also consider just checking for zero in the calculated cell:
=IF(A5=0,"A5 must be non-zero",B5/A5)
will display the result of division OR the message as required

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting

Steam Engine enthusiasts: