| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
and/if statement
I'm trying to write an and/if statement - if possible
IF(((E5-D5)*24)6 AND IF($AO5="Y") then +1 but I can't seem to be entering it correctly. Any suggestions please. -- Thanks, Pat |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
and/if statement
Try it like this:
=IF(AND((E5-D5)*246,$AO5="Y"),............) -- Biff Microsoft Excel MVP "Pat" .(donotspam) wrote in message ... I'm trying to write an and/if statement - if possible IF(((E5-D5)*24)6 AND IF($AO5="Y") then +1 but I can't seem to be entering it correctly. Any suggestions please. -- Thanks, Pat |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
and/if statement
Pat wrote:
I'm trying to write an and/if statement - if possible IF(((E5-D5)*24)6 AND IF($AO5="Y") then +1 but I can't seem to be entering it correctly. Any suggestions please. In general: =IF(AND(first_test),(second_test)),both_tests_true ,either_test_false) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
and/if statement
Glenn wrote:
Pat wrote: I'm trying to write an and/if statement - if possible IF(((E5-D5)*24)6 AND IF($AO5="Y") then +1 but I can't seem to be entering it correctly. Any suggestions please. In general: =IF(AND(first_test),(second_test)),both_tests_true ,either_test_false) Actually, I missed a "("... =IF(AND((first_test),(second_test)),both_tests_tru e,either_test_false) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
and/if statement
this is what I am trying, however still receiving and error. ;(
=IF(AND(E5-D5)*24)6,($AO5="Y")),1,0) First test: (E5-D5)*24)6 Second test: ,($AO5="Y") -- Thanks, Pat "Glenn" wrote: Pat wrote: I'm trying to write an and/if statement - if possible IF(((E5-D5)*24)6 AND IF($AO5="Y") then +1 but I can't seem to be entering it correctly. Any suggestions please. In general: =IF(AND(first_test),(second_test)),both_tests_true ,either_test_false) |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
and/if statement
Sorry . . . I just got it to work with:
=IF(AND((E5-D5)*246,$AO5="Y"),1,0) THANK YOU BOTH so much!! -- Thanks, Pat "T. Valko" wrote: Try it like this: =IF(AND((E5-D5)*246,$AO5="Y"),............) -- Biff Microsoft Excel MVP "Pat" .(donotspam) wrote in message ... I'm trying to write an and/if statement - if possible IF(((E5-D5)*24)6 AND IF($AO5="Y") then +1 but I can't seem to be entering it correctly. Any suggestions please. -- Thanks, Pat |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
and/if statement
Try it like this:
=--AND((E5-D5)*246,$AO5="Y") Enter the formula *exactly* as shown. Don't add or remove any ( ). -- Biff Microsoft Excel MVP "Pat" .(donotspam) wrote in message ... this is what I am trying, however still receiving and error. ;( =IF(AND(E5-D5)*24)6,($AO5="Y")),1,0) First test: (E5-D5)*24)6 Second test: ,($AO5="Y") -- Thanks, Pat "Glenn" wrote: Pat wrote: I'm trying to write an and/if statement - if possible IF(((E5-D5)*24)6 AND IF($AO5="Y") then +1 but I can't seem to be entering it correctly. Any suggestions please. In general: =IF(AND(first_test),(second_test)),both_tests_true ,either_test_false) |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
and/if statement
See my other reply for a better solution.
-- Biff Microsoft Excel MVP "Pat" .(donotspam) wrote in message ... Sorry . . . I just got it to work with: =IF(AND((E5-D5)*246,$AO5="Y"),1,0) THANK YOU BOTH so much!! -- Thanks, Pat "T. Valko" wrote: Try it like this: =IF(AND((E5-D5)*246,$AO5="Y"),............) -- Biff Microsoft Excel MVP "Pat" .(donotspam) wrote in message ... I'm trying to write an and/if statement - if possible IF(((E5-D5)*24)6 AND IF($AO5="Y") then +1 but I can't seem to be entering it correctly. Any suggestions please. -- Thanks, Pat |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
and/if statement
You need to learn to count parentheses, opening and closing.
Look at (E5-D5)*24)6 -- David Biddulph "Pat" .(donotspam) wrote in message ... this is what I am trying, however still receiving and error. ;( =IF(AND(E5-D5)*24)6,($AO5="Y")),1,0) First test: (E5-D5)*24)6 Second test: ,($AO5="Y") -- Thanks, Pat "Glenn" wrote: Pat wrote: I'm trying to write an and/if statement - if possible IF(((E5-D5)*24)6 AND IF($AO5="Y") then +1 but I can't seem to be entering it correctly. Any suggestions please. In general: =IF(AND(first_test),(second_test)),both_tests_true ,either_test_false) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
![Pat[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
