This may not be a VBA-related issue but I am struggling right now and I need your help. I posted this to other Excel groups but I am not getting any response from them.
Here's the scenario: when the user enters a number from 1-6 in C6, I want the program to calculate and give me the answer based on the hours inputted and other info.
C7 - Hours (users enter hours from 1 to 50)
F7– where the formula or result should be
When user enters the following numbers
1 – if C7 =6 hours, 8.50. IF C7 <>6, multiply C7 by 1.40
2 – if C7 =6 hours, 4.25. IF C7 <>6, multiply C7 by 1.40 divide by 2 (or C6?)
3 – if C7 =6 hours, 2.85. IF C7 <>6, multiply C7 by 1.40 divide by 3 (or C6?)
4– if C7 =6 hours, 2.85. IF C7 <>6, multiply C7 by 1.40 divide by 4 (or C6?)
5– if C7 =6 hours, 2.85. IF C7 <>6, multiply C7 by 1.40 divide by 5 (or C6?)
6– if C7 =6 hours, 2.85. IF C7 <>6, multiply C7 by 1.40 divide by 6 (or C6?)
Notice numbers 3 to 6 have the same condition. Is there a one formula for them instead of repeating the formula? I use Excel 2007.Thank you very much and hope to hear from you soon!
Posted by: talacal@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar