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...