Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I want to have a nested IF with two conditions
IF (H6B6 AND I6c6, then put 1, else put 0)
|
#2
|
|||
|
|||
Try this:
=If(And(H6B6,I6C6),1,0) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Mahendra" wrote in message ... IF (H6B6 AND I6c6, then put 1, else put 0) |
#3
|
|||
|
|||
Try...
=IF((H6B6)*(I6C6),1,0) Hope this helps! In article , "Mahendra" wrote: IF (H6B6 AND I6c6, then put 1, else put 0) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why are my nested sub-totals are displaying incorrectly? | Excel Discussion (Misc queries) | |||
Nested IF functions and 3 conditions | Excel Worksheet Functions | |||
Nested IF statements | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
€śUse of more then 7 nested if statement€ť | Excel Worksheet Functions |