Cell result dependant on a word
 

I require help with a formula that does one thing unless another cell has a
particular word in it then it does something different.

e.g
C55 has the formula B7*.6

But if F19 say Bare Land I need the answer in C55 to be 0

so =if((b7="","",B7*0.6,if(f19="Bare Land",0))

Where am I going wrong?
--
Thanks in advance.

Scoober

Cell result dependant on a word
 

=if(F19="Bare Land",0,if(B7="","",B7*0.6))

"Scoober" wrote:

I require help with a formula that does one thing unless another cell has a
particular word in it then it does something different.

e.g
C55 has the formula B7*.6

But if F19 say Bare Land I need the answer in C55 to be 0

so =if((b7="","",B7*0.6,if(f19="Bare Land",0))

Where am I going wrong?
--
Thanks in advance.

Scoober

Cell result dependant on a word
 

=IF(F19="Bare Land",0,IF(B7="","",B7*0.6))

If this post helps click Yes
---------------
Jacob Skaria


"Scoober" wrote:

I require help with a formula that does one thing unless another cell has a
particular word in it then it does something different.

e.g
C55 has the formula B7*.6

But if F19 say Bare Land I need the answer in C55 to be 0

so =if((b7="","",B7*0.6,if(f19="Bare Land",0))

Where am I going wrong?
--
Thanks in advance.

Scoober

Cell result dependant on a word
 

Altough this completes the formula correctly it doesn't calculate a 0 when
Bare Land is written in f19?
--
Thanks in advance.

Scoober


"Sam Wilson" wrote:

=if(F19="Bare Land",0,if(B7="","",B7*0.6))

"Scoober" wrote:

I require help with a formula that does one thing unless another cell has a
particular word in it then it does something different.

e.g
C55 has the formula B7*.6

But if F19 say Bare Land I need the answer in C55 to be 0

so =if((b7="","",B7*0.6,if(f19="Bare Land",0))

Where am I going wrong?
--
Thanks in advance.

Scoober

Cell result dependant on a word
 

Check out for any spaces...
OR try

=IF(TRIM(F19)="Bare Land",0,IF(B7="","",B7*0.6))

If this post helps click Yes
---------------
Jacob Skaria


"Scoober" wrote:

Altough this completes the formula correctly it doesn't calculate a 0 when
Bare Land is written in f19?
--
Thanks in advance.

Scoober


"Sam Wilson" wrote:

=if(F19="Bare Land",0,if(B7="","",B7*0.6))

"Scoober" wrote:

I require help with a formula that does one thing unless another cell has a
particular word in it then it does something different.

e.g
C55 has the formula B7*.6

But if F19 say Bare Land I need the answer in C55 to be 0

so =if((b7="","",B7*0.6,if(f19="Bare Land",0))

Where am I going wrong?
--
Thanks in advance.

Scoober

Cell result dependant on a word
 

It should...

Are you putting the formula in cell C55?

"Scoober" wrote:

Altough this completes the formula correctly it doesn't calculate a 0 when
Bare Land is written in f19?
--
Thanks in advance.

Scoober


"Sam Wilson" wrote:

=if(F19="Bare Land",0,if(B7="","",B7*0.6))

"Scoober" wrote:

I require help with a formula that does one thing unless another cell has a
particular word in it then it does something different.

e.g
C55 has the formula B7*.6

But if F19 say Bare Land I need the answer in C55 to be 0

so =if((b7="","",B7*0.6,if(f19="Bare Land",0))

Where am I going wrong?
--
Thanks in advance.

Scoober

Cell result dependant on a word
 

Does it matter that Bare Land is populated into F19 via a drop down list?
--
Thanks in advance.

Scoober


"Jacob Skaria" wrote:

=IF(F19="Bare Land",0,IF(B7="","",B7*0.6))

If this post helps click Yes
---------------
Jacob Skaria


"Scoober" wrote:

I require help with a formula that does one thing unless another cell has a
particular word in it then it does something different.

e.g
C55 has the formula B7*.6

But if F19 say Bare Land I need the answer in C55 to be 0

so =if((b7="","",B7*0.6,if(f19="Bare Land",0))

Where am I going wrong?
--
Thanks in advance.

Scoober

Cell result dependant on a word
 

On Tue, 4 Aug 2009 02:58:01 -0700, Scoober
wrote:

Altough this completes the formula correctly it doesn't calculate a 0 when
Bare Land is written in f19?

Most likely, F19 does not really contain "Bare Land". There may be extraneous
non-printing characters. Or the space between the two words may not be ASCII
code 32.

--ron