Avatar of sarics
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.
Microsoft Excel

Avatar of undefined
Last Comment
sarics

8/22/2022 - Mon
Subodh Tiwari (Neeraj)

A sample workbook with desired output would be helpful.
sarics

ASKER
ASKER CERTIFIED SOLUTION
Rgonzo1971

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
sarics

ASKER
Thank you, you 're a magician :-) work perfectly.
Your help has saved me hundreds of hours of internet surfing.
fblack61