IF, Then

  • Thread starter Thread starter jolene
  • Start date Start date
J

jolene

How do I use a calculation like If cell X contains X then calculate one
formula, if not then calculate a different one?

Thanks form a newbie
 
Jolene

=IF(A1="x", A2+A3,B2+B3)

Have a look at the Help in Excel. There are several examples there.

Regards

Trevor
 
Depends. Are you wanting to test for just one character within the cell or
all the information in the cell? If the latter, is this text or a number.

If you could give some more detail of what you are wanting to do you could
get help specific to you problem.

In general though in A2 -

=IF(A1= "X",A1*1,A1*2)

Regards

Bill Ridgeway
Computer Solutions
 
Hello,
Here is specifically what I want to do...
If cell A1 has like Baker T in cell A1. I want to calculate a formula based
on wheatear the "T" is there or another if the "T" is not there. Has
something to do with extracting a string value

Thanks for your help
 
Back
Top