Excel 2007 : Help on If statement with three cells conditions with short formula

[nityagajeli]

Hello,

I wud like to give three conditions in a single cell.

Below is an example :

Point 1 : If cell B1=1 then check C1=True, if both conditions are correct then check D1=Yes. If these three conditions are success, insert the value as 100 in A1.

Point 2 : If cell B1=2 then check C1=True, if both conditions are correct then check D1=Yes. If these three conditions are success, insert the value as 200 in A1.

Point 3 : If cell B1=3 then check C1=True, if both conditions are correct then check D1=Yes. If these three conditions are success, insert the value as 300 in A1.

Point 4 : If cell B1=1 then check C1=False, if both conditions are correct then check D1=Yes. If these three conditions are success, insert the value as 400 in A1.

Point 5 : If cell B1=2 then check C1=False, if both conditions are correct then check D1=Yes. If these three conditions are success, insert the value as 500 in A1.

Point 6 : If cell B1=3 then check C1=False, if both conditions are correct then check D1=Yes. If these three conditions are success, insert the value as 600 in A1.

Point 7 : If cell B1=1 then check C1=True, if both conditions are correct then check D1=No. If these three conditions are success, insert the value as 700 in A1.

Point 8 : If cell B1=2 then check C1=True, if both conditions are correct then check D1=No. If these three conditions are success, insert the value as 800 in A1.

Point 9 : If cell B1=3 then check C1=True, if both conditions are correct then check D1=No. If these three conditions are success, insert the value as 900 in A1.

Point 10 : If cell B1=1 then check C1=False, if both conditions are correct then check D1=No. If these three conditions are success, insert the value as 1000 in A1.

Point 11 : If cell B1=2 then check C1=False, if both conditions are correct then check D1=No. If these three conditions are success, insert the value as 1100 in A1.

Point 12 : If cell B1=3 then check C1=False, if both conditions are correct then check D1=No. If these three conditions are success, insert the value as 1200 in A1.

Sorry, in case, if conditions makes u difficult to understand.

Thanks in advance for your help!

Regards,
NG

[NBVC]

Try:

Please Login or Register  to view this content.

[Marcol]

Another way?

Please Login or Register  to view this content.