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

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

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 3: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 4: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