# 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

• Level 1:

An expert who has achieved level 1.

Corporal:

An expert that hasĀ over 10 points.

Problem Solver:

An expert who has answered 5 questions.

• Contributor

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

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### 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...

=INT(A1)+0.95

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

Bob
Moderator

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

### Use formulas

Hi!

Go to this site, there you will find exellent training to learn all about excel
http://office.microsoft.com/en-us/excel/CH102248311033.aspx

Good luck
Nic

Apr 01, 2009 | Microsoft Computers & Internet

### 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.
Thanks

Zulfikar Ali
ali_zulfikar@yahoo.com
09899780221

Jan 19, 2009 | Microsoft Office Excel 2003 for PC

### Need a range answer in excel

Yes, Concatenate is the name of the formula.

ex:
=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.
ex.
=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

### Excel formulas

=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

### Hi..

Jul 31, 2008 | Microsoft Excel for PC

### 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:
=IF(A5>\$B\$1,(\$B\$2*\$B\$1)+((A5-\$B\$1)*(\$B\$3)),A5*\$B\$2)

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.

Oct 22, 2007 | Microsoft Excel 2003 (06503995)

## Open Questions:

#### Related Topics:

186 people viewed this question

Level 3 Expert

Level 3 Expert