Please help with this formula:

If a number 1 is inserted into O85, a number 2 is automatically inserted in
I32.
--
~~Rob

I somehow think you may have simplified your question too much for posting
to this newsgroup (Is the 2 an absolute relation to a 1 in O85 as your post
suggests? Or is it one more than the contents of O85? Or is it twice
whatever is in O85?). Anyway, to answer the question you posted, put this in
I32...

=IF(O85=1,2,"")

where I assumed you wanted I32 to be blank if O85 did not contain a one.

Rick


"Rob" wrote in message
...
Please help with this formula:

If a number 1 is inserted into O85, a number 2 is automatically inserted
in
I32.
--
~~Rob

Great, thanks!
--
~~Rob


"Rick Rothstein (MVP - VB)" wrote:

I somehow think you may have simplified your question too much for posting
to this newsgroup (Is the 2 an absolute relation to a 1 in O85 as your post
suggests? Or is it one more than the contents of O85? Or is it twice
whatever is in O85?). Anyway, to answer the question you posted, put this in
I32...

=IF(O85=1,2,"")

where I assumed you wanted I32 to be blank if O85 did not contain a one.

Rick


"Rob" wrote in message
...
Please help with this formula:

If a number 1 is inserted into O85, a number 2 is automatically inserted
in
I32.
--
~~Rob

Rob --

In I32, enter:

=IF(O85=1,2,"Not 1")

Put whatever you want in the 'Not 1' part. If you want it blank, it looks
like "". That's two double quotations.

HTH

"Rob" wrote:

Please help with this formula:

If a number 1 is inserted into O85, a number 2 is automatically inserted in
I32.
--
~~Rob

Perfect, thanks.
--
~~Rob


"pdberger" wrote:

Rob --

In I32, enter:

=IF(O85=1,2,"Not 1")

Put whatever you want in the 'Not 1' part. If you want it blank, it looks
like "". That's two double quotations.

HTH

"Rob" wrote:

Please help with this formula:

If a number 1 is inserted into O85, a number 2 is automatically inserted in
I32.
--
~~Rob

As Rick pointed out, you probably have simplifies you needs.

Maybe more numbers needed?

=LOOKUP(O85,{1,2,3,4,5,6,7},{2,4,6,8,10,12,14}) entered in I32


Gord Dibben MS Excel MVP


On Mon, 14 Jul 2008 14:49:01 -0700, Rob wrote:

Please help with this formula:

If a number 1 is inserted into O85, a number 2 is automatically inserted in
I32.