Help please with vb programming

[Guest]

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

 

[Guest]

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

 

[Guest]

Hi bernard,

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

Sorry for taking up your time

 

[Guest]

Not a waste of time if you have solved your problem
cheers