Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Logical if more than 7
A B C D
E F 1 shape of bar a b c formula required 2 BB 3 TB 4 S 5 L 6 SB 7 Z 8 ST 9 CH 10 SCB1 11 SCB2 12 HR I WANT THE FORMULA IN F2 IF B2=BB OR TB OR S OR SB OR Z OR SCB1 OR SCB2 THEN F2= C2+D2+E2 THEN , IF B2=ST THEN F2=2*( C2+D2+E2) ,IF B2=TB THEN C2+D2+E2, IF B2=HR THEN F2= 8*A+2*B. PLEASE DO THE NEEDFUL. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Logical | Excel Discussion (Misc queries) | |||
Logical Functions | Excel Worksheet Functions | |||
Logical Functions | Excel Worksheet Functions | |||
Logical Value | Excel Worksheet Functions | |||
SUM for logical values | Excel Discussion (Misc queries) |