perform a calculation when a certain phrase appears in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to build a spreadsheet to perform a arithematic when a phrase
appears in a cell (ie: Yes or NO)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The sum of data based on words 3
Finding Duplicate Phrases in a File 2
Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4
Selecting a Keyword for Macro: 4
Excel Typed text appears in wrong cell 0
Formatting one cell based on the contents of another cell 2
Issue with blanks and spaces 56
Conditional format when text contains using cell reference 4

Back
Top