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.