If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel Query

rockman15 · 2010-08-26 15:15:37

Hi Guys First time poster here. Im looking to set up a automatically generated response for one column in excel based on the preceding one. ie: when I enter "2" into column A I want the corresponding cell in column B to return "Not Applicable" I havent a breeze how to do it and tried to set it using various input formulae…

26-08-2010 04:15PM

#1

rockman15

Registered Users, Registered Users 2 Posts: 277 ✭✭

Join Date: February 2008

Posts: 251

Hi Guys

First time poster here.

Im looking to set up a automatically generated response for one column in excel based on the preceding one.

ie: when I enter "2" into column A I want the corresponding cell in column B to return "Not Applicable"

I havent a breeze how to do it and tried to set it using various input formulae but nothing worked for me...

Any help is VERY appreciated

Steve

0

Comments

#2 26-08-2010 05:55PM

Dulchie

Registered Users, Registered Users 2 Posts: 209 ✭✭

Join Date: February 2006

Posts: 183

insert the following in B1 =IF(A1=2,"Not Applicable","")

0