Programming

Programming questions? Ask a programmer for answers ASAP

Ask a Computer Expert,

Get an Answer ASAP!

need a formula which will...

need a formula which will do the following:

calculate salary $$ x 0.09 if this amount comes back above $15,199.20 then the amount shown is $15,199.20 and if it is below then is amount salary $$ x 0.09 but if there is no salary $$ then cell is left blank with no value error

calculate salary $$ x 0.09 if this amount comes back above $15,199.20 then the amount shown is $15,199.20 and if it is below then is amount salary $$ x 0.09 but if there is no salary $$ then cell is left blank with no value error

Show More

Show Less

Was this answer helpful?

Describe your issueThe assistant will guide you

Chat 1:1 with a programmerLicensed Experts are available 24/7

100% satisfaction guaranteeGet all the answers you need

Related Programming Questions

My excel sheet is not functioning correctly. I have inserted

My excel sheet is not functioning correctly. I have inserted a formula directing each cell in a column of cells to take the value of the cell above it in that same column, add the value in the cell in… read more

What is the formula to take 5% of a number over a certain

What is the formula to take 5% of a number over a certain amount, but not 5% under that amount? … read more

I need 3-4 formulas written. One is for a calculation of time

I need 3-4 formulas written. One is for a calculation of time between 'check in' and 'check out' in terms of days and hours (i.e., 8:37am until 4:15pm same day represents 9.87 hours) but the same time… read more

Complete Problem 4 on p. 350 in Ch. 6 of Prelude to

Complete Problem 4 on p. 350 in Ch. 6 of Prelude to Programming. You are required to generate only the pseudocode, as described in the Week Two CheckPoint. No charting is required, but you may have to… read more

I am trying to create a formula that has a number of variables

I am trying to create a formula that has a number of variables but the formula would calculate the maximum amount that could be paid to generate a return of either 3%, 4%, or 5%. I have started inputt… read more

How do I write a formula for the following I need unit cost in cell B4 x quantity C4 x fr

How do I write a formula for the following: I need unit cost in cell B4 x quantity C4 x frequecy D4 to total in E4. but if C4 and D4 are blank then B4 is the total?… read more

I need to figure out the following formula. For example I

I need to figure out the following formula. For example I have $38,000,000 in sales, I need to be able to calculate the following formula: 1% of sales under $32,000,000 and 2% of sales in excess of $3… read more

I wish to include in a formula in Excell a function to find

I wish to include in a formula in Excell a function to find the Minimum value above zero in a long series of values that excludes zero values or empty cells.… read more

Hi John, I have a spreadsheet that is being used to depreciate

Hi John, I have a spreadsheet that is being used to depreciate assets. I am trying to put a formula into the depreciation cell that looks at other cells to decide at what rate and for how long the cha… read more

I am trying to create a formula that takes an average of non-consecutive

I am trying to create a formula that takes an average of non-consecutive cells within the same row. Only of those cells greater than zero. The row is a series of dollar amounts each followed by a cell… read more

I am looking to create a formula which calculates if a celll

I am looking to create a formula which calculates if a celll is over 100,000 then it should only calculate a percentage upto that 100,000 and not any further. For example I have a cell that says 107,3… read more

Your suggestion did work for the cell in question, although

Your suggestion did work for the cell in question, although now, after inputting the formula, I get error messages (#VALUE!) in other columns that did not have the errors before. I would like to accep… read more

Hello, I need to create a formula and save it for future

Hello, I need to create a formula and save it for future use in excel. Here is the formula: A - (A - 25.00 x 3.5%) – 8.19 – (A x 1.9% + 0.3) + [(A – 25.00 x 3.5% + 2.19) x .2] I want to be able to ent… read more

Excel 2003 - I have a column with this format - 1400 [427 SqMt]

Excel 2003 - I have a column with this format - 1400 [427 SqMt] - I need to extract the "1400" into it's own column (I know I can use text to column, but I want the answer to be at the end of all of m… read more

The answer helped a lot but i still have a problem the dollar

The answer helped a lot but i still have a problem the dollar amount needs to be right justified and the spreadsheet i am using is protected and cannot use currency buttom the formula i am using is =D… read more

I have a spreadsheet at work that lists jobs and hours worked,

I have a spreadsheet at work that lists jobs and hours worked, it also lists the total amount of each per day in every other cell at the bottom of the worksheet. I need to come up with a formula that … read more

I am trying to create an excel formula to calculate a match

I am trying to create an excel formula to calculate a match of 100% on the first 3% of pay and 50% on each of the next 2% of pay on all pay up to $245,000.… read more

Im working on an excel formula, but cant seem to get the

I'm working on an excel formula, but can't seem to get the calculation right. I want the formula to multiply cell1=100 X cell2=60-cell value, but i want the criteria to be that it will only multiply w… read more

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.

JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.

Web sites like justanswer.com/legal

...leave nothing to chance.

...leave nothing to chance.

Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.

Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.

I will tell you that...the things you have to go through to be an Expert are quite rigorous.

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

New York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

Los Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

Hesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

Kernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

Woodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

Elkton, Maryland

< Previous | Next >

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

Computer Software Engineer

7,175 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

Software Engineer

848 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.