Using a word in logic functions (instead of a number)

H

hillan2

I'm working on MSExcel 2007. I was wondering if there was a way to reference
a word in a function. Specifically, i need a logic function along the
following lines:

If cell A2 says "No" (is true) then value equals 2 times cell B2, if not,
value equals B5
 

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

an IF function that can take no action? 5
Using two Vlookup in one Cell 1
Logic function 2
Contains instead of Equal 4
How can I use a sheet in a formula based on the value in a cell 2
Can I include a "validation drop down" in a conditional statement? 1
Paste Special Multiply Formulas not working in Excel 2007 1
Using Variables in a Reference 1

Top