Hi bernard,

thank you. I guess i had a mind block on it.

Sorry for taking up your time

"Bernard Liengme" wrote:

Is this really a VBA question when a simple Excel formula will do the trick
In E5 type this
=IF(A5=1,d5/$b$2*26,d5/$b$1*12)
You willneed to change A5=1 to your own (unspecified) test
best wishes
--
www.stfx.ca/people/bliengme


"umpire_43" wrote:

Hi there,

Hopefully, someone can help?????

This is what i want to do:

1) a formula meet that condition in column A put this formula in Column e5
d5/$b$2*26 ...if it doesn't meet the condition then put e5=d5/$b$1*12
2) the formula in column e will change based on rows that will change every
month.

Can you help me?
Thanks