IF formula

[Joy079]

Hi Guys,
Im using this formula =IF(A2="Auto","ok","not ok")

When I copy the formula down I want to the blank fields to appear Blank.

How do I update this formula please??

[kersplash]

Try this;

=IF(A2="","",IF(A2="Auto","ok","not ok"))

[Joy079]

thanks!

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.