hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,214
- Office Version
- 2010
- Platform
- Windows
- Mobile
I want to get 10, 20, 30 or 40 in F2 as:
F2=10 IF B2=0 AND C2=TRUE
F2=20 IF B2=0 AND C2=FALSE
F2=10 IF B2=1 AND C2=TRUE
F2=10 IF B2=1 AND C2= FALSE
ELSE
F2=0
How to accomplish.
Thanks in advance.
I am using Excel 2007
Sheet1
<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 94px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
</tbody>
F2=10 IF B2=0 AND C2=TRUE
F2=20 IF B2=0 AND C2=FALSE
F2=10 IF B2=1 AND C2=TRUE
F2=10 IF B2=1 AND C2= FALSE
ELSE
F2=0
How to accomplish.
Thanks in advance.
I am using Excel 2007
Sheet1
B | C | D | E | F | |
1 | 1 or 0 | TRUE or FALSE | |||
2 | 1 | TRUE | 10 |
<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 94px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
</tbody>