View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam Wilson Sam Wilson is offline
external usenet poster
 
Posts: 523
Default 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