Thread: perform a calculation when a certain phrase appears in a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dav Dav is offline
external usenet poster
  
Posts: 1
Default perform a calculation when a certain phrase appears in a cell

If it is only 2 phrases use if statements, if the value you are
interested in is in cell A1 and the phrases are YEs and No

If(a1="Yes",the calculation if it is yes,if(a1="No","the calculation if
it is no",""))

Eg
=if(a1="Yes", c1*d1,if(a1="No",d1*e1,""))

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=558712

Reply With QuoteReply With Quote