14-09-2021 10-05-55.png
I control the company workers' income, and I have to enter their salaries per month and year. What formula should I put into D2, D3, and D4 to count their annual salary depending on their monthly income?
14-09-2021 10-05-55.png
I control the company workers' income, and I have to enter their salaries per month and year. What formula should I put into D2, D3, and D4 to count their annual salary depending on their monthly income?
Welcome to the forum, Max. Not sure if this is a trick question. Put the formula "=C2*12" (without the quotation marks) in cell D2, copy down.
I agree that this seems pretty obvious - monthly salary * 12.
On a side not, this is hardly a "counting" question, as your thread title suggests. Please give more thought to your title next time, we need something that describes your problem (eg this could have been "How to calc annual salary from monthly salary")
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
Max looks as if he is trying to build his post count by posting very basic questions, and then not responding to answers. I have my eye on him ... Behaviour is somewhat suspicious.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I'm not going to ignore the questions. To be honest, I've just started using Excel and finding out something new about it only about a month ago, and I don't have any tutor to help me get into this. That's why my questions may sound a little bit dumb or too obvious to be answered here. Thanks for all of you for your answers
All the more reason to put more thought into your thread titles. Always think, "What am I trying to achieve?" The answer will usually give you an appropriate title. You don't need to worry about HOW it might be done.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
@Max O'Brian
some ways you can learn how to use excel, without asking such basic questions:
1. use the forum "search" function, go and read posts of others and and even get their files.
2. use google search, for the basic questions you are currently posting there are thousands of pages that answer them in google.
3. do some free excel courses, heres one that might suit you: https://spreadsheeto.com/
Max, we all had to start somewhere, learning this immense program. We are here to help, so ask away - but keep in mind we require descriptive thread titles
The COUNT function counts the number of cells that have numbers in them, as well as the amount of numbers in the list of parameters. For example, to count the numbers in the range A1:A20, use the following formula: =COUNT (A1:A20)
I am extremely pleased with your kindness, thanks a lot for helping me to use this forum more correctly
Thank you for your advice!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks