| 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 |
| 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) | |||
Threaded Mode
