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

  • Thread starter Thread starter hillan2
  • Start date Start date
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
 
Back
Top