Question about Business & Productivity Software

1 Answer

Getting the excel formula

Hi. im trying to figure out how to get the formula for this

$ + 25% x 1.5 =

how can i input that on microsoft excel using a formula.

pls pls pls, i need your help !!! NEED THE FORMULA

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 16 Answers
Re: getting the excel formula

Suppose the value for $ is stored in cell A3. Your formula would look like this: =(A3+A3*0.25)*1.5

The equals sign at the beginning of the formula is necessary. And if you want the result to be formatted as currency, you can do so by right-clicking the cell or column, format cell, number tab, choose currency.

Posted on Nov 15, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer

I need help with an excel formula. I am looking to get to a retail price, knowing the cost and the margin. For example, the cost is $10.00, margin is 25%, so my formula would be =10/75%. The total would be...


With A1 being the reference to the cell you wish to round up
What that does is first round down the number to a whole one then adds 0.95 to the figure

Hope this gives you the information you need


It would be very decent of you to consider the quality of our expert’s answers and judge them accordingly as you pass through FixYa.

Thank you

Mar 17, 2010 | Microsoft Excel 2003 (065-03992) for PC

1 Answer

Use formulas


Go to this site, there you will find exellent training to learn all about excel

Good luck

Apr 01, 2009 | Microsoft Business & Productivity Software

1 Answer

I want verify the data drop town list and its formulas

Hi Manjee,

There is no formula used in data dropdown list, so it can not be verified as a formula using evaluate formula, trace errors, trace dependents, trace precedents etc.

If you want to create such lists simply:-
  • Select input range then goto
    data --> validation --> allow, list --> select the list range
  • To veryfy you can follow the same process
    data --> validation --> allow, list ,
    now you can see the exact range from where the data is picked.

Zulfikar Ali

Jan 19, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Need a range answer in excel

Yes, Concatenate is the name of the formula.

=CONCATENATE(.15*B27," to ",.25*B27)
Which would return something like: "15.1254 to 25.5514"

If you want to limit the numbers in the returned data to whole numbers, you need to add the Floor formula.
=CONCATENATE(FLOOR(.15*B27,1)," to ",FLOOR(.25*B27,1))
That would return something like "15 to 25"

Dec 19, 2008 | Microsoft Excel for PC

2 Answers

Excel formulas

Here is your formula

=IF(A1 < 25,10/100 * B1, 5/100 * B1)

A1 is the Age of client
B1 is the car value

Oct 27, 2008 | Microsoft Excel for PC

1 Answer


Download this pdf, and it will help you get started with Excel.

Jul 31, 2008 | Microsoft Excel for PC

3 Answers

Excel argument

If I understand correctly, you want to figure the normal wages at 40 hours and less. If there is more then 40 hours, calculate the normal 40 hours, then calculate the hours overtime (time and a half) and add them to get a total.


B5 columns are filled with this:

NOTE: The $ sign doesn't refer to money, it refers to an absolute reference so when copying a formula, the cell references with a $ sign are fixed and don't adjust according to the relative position to where it's being pasted.

Please rate as FixYa! or ask please clarify. ThankYa!

Oct 22, 2007 | Microsoft Excel 2003 (06503995)

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

175 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides