ExcelBanter - perform a calculation when a certain phrase appears in a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - perform a calculation when a certain phrase appears in a cell (https://www.excelbanter.com/excel-worksheet-functions/97738-perform-calculation-when-certain-phrase-appears-cell.html)

Eddie_of_Succasunna

perform a calculation when a certain phrase appears in a cell

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

Dav

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

All times are GMT +1. The time now is 04:45 PM.