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