sarics

asked on

# excel macro If and and and or then

Hello expert,

please can you help me

If C column have 0000 and D column=1 and E column=2 and A column 3 or 5 then sum B column +18 and then result put in C column and color yellow

If C column have 0000 and D column=1 and E column=2 and A column 4 or 6 then sum B column +21 and if sum B column+21=<2006 put 2006 in C column and if is not put result in C column and color green.

thx.

please can you help me

If C column have 0000 and D column=1 and E column=2 and A column 3 or 5 then sum B column +18 and then result put in C column and color yellow

If C column have 0000 and D column=1 and E column=2 and A column 4 or 6 then sum B column +21 and if sum B column+21=<2006 put 2006 in C column and if is not put result in C column and color green.

thx.

A sample workbook with desired output would be helpful.

ASKER

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Thank you, you 're a magician :-) work perfectly.