| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a word in logic functions (instead of a number)
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using a word in logic functions (instead of a number)
hi,
=IF(A2="No",B2*2,B5) Mike "hillan2" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using a word in logic functions (instead of a number)
=IF(A2="No",B2*2,B5) Gord Dibben MS Excel MVP On Wed, 14 Jan 2009 13:21:00 -0800, hillan2 wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set two different (AND & OR) logic functions within one | Excel Discussion (Misc queries) | |||
| How do I set two different (AND & OR) logic functions within one | Excel Discussion (Misc queries) | |||
| How do I set two different (AND & OR) logic functions within one | Excel Discussion (Misc queries) | |||
| logic (IF) functions | Excel Worksheet Functions | |||
| Need help setting up a formula using perhaps the logic functions . | Excel Worksheet Functions | |||
Linear Mode
