Help please with vb programming
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 |
Help please with vb programming
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 |
Help please with vb programming
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 |
Help please with vb programming
Not a waste of time if you have solved your problem
cheers -- www.stfx.ca/people/bliengme "umpire_43" wrote: 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 |
All times are GMT +1. The time now is 01:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com