Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Programming | New Users to Excel | |||
Programming | Excel Discussion (Misc queries) | |||
vba programming | Excel Discussion (Misc queries) | |||
New to Programming | Excel Programming | |||
Programming lag | Excel Programming |