IF formulas

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I'm trying to enter a formual that would say "if a cell
has one text statement, then a different cell shows
another text statement." For instance, if B2
says "window" then H2 says "call for window quote." In
this case, I want the H2 statement to automatically appear
if someone chooses "windows" from a list in B2. I'd
appreciate any assistance on this. Thank you!
 
You should be able to put an IF formula in the cell you
want to display the information. For example in cell H2
you would put:

if (B2="window","Call for a window quote.","what you want
it to say if it's not")

If you do not want it to say anything just put "" with
nothing in between the 2.

the format is always

if ([cell to compare] [comparison symbol] [text or number
to compare it to],[text if true],[text if false])
 
That worked! It was the "" that threw me. Can I add to
the formula if B2 says something else and I want a
different corresponding statement in H2? Thanks.

-----Original Message-----
You should be able to put an IF formula in the cell you
want to display the information. For example in cell H2
you would put:

if (B2="window","Call for a window quote.","what you want
it to say if it's not")

If you do not want it to say anything just put "" with
nothing in between the 2.

the format is always

if ([cell to compare] [comparison symbol] [text or number
to compare it to],[text if true],[text if false])
-----Original Message-----
I'm trying to enter a formual that would say "if a cell
has one text statement, then a different cell shows
another text statement." For instance, if B2
says "window" then H2 says "call for window quote." In
this case, I want the H2 statement to automatically appear
if someone chooses "windows" from a list in B2. I'd
appreciate any assistance on this. Thank you!
.
Click to expand...
.
Click to expand...
 
Hi

This (solution from anonymus) will work only, when the formula has to react
only to entry "window", or to absence of it. But when B2 can contain various
entries, and for every of them has to be a different response?

Add a sheet p.e. Responses with 2-column table:
ListItem, Response

Define 2 named ranges (Insert.Name.Define)
List=OFFSET(Responses!$A$2,,,COUNTIF(Responses!$A:$A,"<>")-1,1)
Responses=OFFSET(Responses!$A$2,,,COUNTIF(Responses!$A:$A,"<>")-1,2)

The named range List you can use as source for validation list in cell B2

Into H2 enter the formula
=VLOOKUP(B2,Responses,2,0)


--
Arvi Laanemets
(Don't use my reply address - it's spam-trap)


You should be able to put an IF formula in the cell you
want to display the information. For example in cell H2
you would put:

if (B2="window","Call for a window quote.","what you want
it to say if it's not")

If you do not want it to say anything just put "" with
nothing in between the 2.

the format is always

if ([cell to compare] [comparison symbol] [text or number
to compare it to],[text if true],[text if false])
-----Original Message-----
I'm trying to enter a formual that would say "if a cell
has one text statement, then a different cell shows
another text statement." For instance, if B2
says "window" then H2 says "call for window quote." In
this case, I want the H2 statement to automatically appear
if someone chooses "windows" from a list in B2. I'd
appreciate any assistance on this. Thank you!
.
Click to expand...
Click to expand...
 
Back
Top