Formula question

R

Rob

Please help with this formula:

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

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
 
P

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
 
R

Rob

Great, thanks!
--
~~Rob


Rick Rothstein (MVP - VB) said:
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
Click to expand...
 
R

Rob

Perfect, thanks.
--
~~Rob


pdberger said:
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
Click to expand...
 
G

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
 
Top