Auto populate based on frequency
Hi,
Attached is my worksheet.
I am trying to auto populate columns E to P by taking the invoice amount, frequency and the start date and then applying it appropiately. So far, I have a simple IF statement.
=IF(B2="Quarterly",A2/4,IF(B2="Monthly",A2/12,IF(B2="Annually",A2,0))
Thoughts?
Thanks,
cro0sh.
Wrong post..sorry
Is this what you wanted? put in E2 and copy down and across...
=IFERROR($A2/IF(AND($B2="annually",COUNTA($E$1:E$1)>1),"",IF(AND($B2="Quarterly",COUNTA($E$1:E$1)>4),"",IF($B2="Quarterly",4,IF($B2="Monthly",12,1)))),"")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks