| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"IF AND" statement
I'm trying to get this formula to work.
IF V55 equal 1 and V34 is less than or equal to 10 and V35 is less than or equal to 10 then I want a "1" or a "0" I get a "1" or a "False" with the formula below. Any idea how to get the "1" or "0" =IF(V55=1,AND(V34<=10,AND(V35<=10,1,0))) -- Buddy Roe |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"IF AND" statement
Try this:
=IF(AND(V55=1,V34<=10,V35<=10),1,0) HTH, Elkar "Buddy Roe" wrote: I'm trying to get this formula to work. IF V55 equal 1 and V34 is less than or equal to 10 and V35 is less than or equal to 10 then I want a "1" or a "0" I get a "1" or a "False" with the formula below. Any idea how to get the "1" or "0" =IF(V55=1,AND(V34<=10,AND(V35<=10,1,0))) -- Buddy Roe |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"IF AND" statement
Yahoo it works - thanks
-- Buddy Roe "Elkar" wrote: Try this: =IF(AND(V55=1,V34<=10,V35<=10),1,0) HTH, Elkar "Buddy Roe" wrote: I'm trying to get this formula to work. IF V55 equal 1 and V34 is less than or equal to 10 and V35 is less than or equal to 10 then I want a "1" or a "0" I get a "1" or a "False" with the formula below. Any idea how to get the "1" or "0" =IF(V55=1,AND(V34<=10,AND(V35<=10,1,0))) -- Buddy Roe |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SQL concatenation statement | Excel Discussion (Misc queries) | |||
| CREATE AN "IF' STATEMENT FOR CHOICES OF CHECK BOXES | Excel Worksheet Functions | |||
| SET statement tutorial | Excel Discussion (Misc queries) | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Linear Mode
