View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Formula question

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