| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change text format dependant on formula result | Excel Worksheet Functions | |||
| Cell text and background colour dependant on result | Excel Worksheet Functions | |||
| Show or blank out a cell dependant on an selection in another cell | Excel Discussion (Misc queries) | |||
| Returning a Value from a Table, dependant on the word Typed | Excel Worksheet Functions | |||
| can i delete cells dependant on the result from a formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
