Formula question

[Rob]

Please help with this formula:

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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[pdberger]

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]

Great, thanks!
--
~~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]

Perfect, thanks.
--
~~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

 

[Gord Dibben]

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