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

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

Try this tutorial: [LINK]

Aug 31, 2012 | Microsoft Office Excel 2007 Full Version...

=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

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

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

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 Business & Productivity Software

Put the below formula in column C1 and then drag down for other values. Please rate me if this helps. please.

=(A1* -1)

=(A1* -1)

Mar 11, 2009 | Microsoft Office Excel 2003 for PC

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:-

Zulfikar Ali

ali_zulfikar@yahoo.com

09899780221

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

ali_zulfikar@yahoo.com

09899780221

Jan 19, 2009 | Microsoft Office Excel 2003 for PC

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"

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

Here is your formula

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

A1 is the Age of client

B1 is the car value

=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

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

www.whitman.edu/geology/winter/**Excel**.pdf

www.whitman.edu/geology/winter/

Jul 31, 2008 | Microsoft Excel for PC

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.

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

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.

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

Oct 22, 2007 | Microsoft Excel 2003 (06503995)

Oct 21, 2016 | The Business & Productivity Software

175 people viewed this question

Usually answered in minutes!

×