perform a calculation when a certain phrase appears in a cell

  • Thread starter Eddie_of_Succasunna
  • Start date
E

Eddie_of_Succasunna

I am trying to build a spreadsheet to perform a arithematic when a phrase
appears in a cell (ie: Yes or NO)
 
D

Dav

If it is only 2 phrases use if statements, if the value you ar
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 i
it is no",""))

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

Regards

Da
 
Top