# formula to calculate percentage

#### percenthelp

##### New Member
[FONT=&quot]how to create formulas to reduce 25% of the Salaries Expenses by multiplying the Salaries Expense for each month by 75%.

i know it \$ signs are involved something like \$a\$1 *100 +.75 i dont know for sure does anyone know an answer to this?
[/FONT]

Last edited:

### Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Try

=A1*75%

#### percenthelp

##### New Member
Try

=A1*75%
No it didnt work
i have \$4000 in a1 now i need 75% of a1 in the same cell using the percentage formula

#### Scott Huish

##### MrExcel MVP
Put it in a different cell. Otherwise you will need VBA, which is as follows:

Code:
``````Sub test()
If IsNumeric(Range("A1")) Then Range("A1") = Range("A1") * 0.75
End Sub``````

#### Gerald Higgins

##### Well-known Member
You're going to struggle with this, because this will create a circular reference.

If A1 contains \$4,000, and you then want A1 to contain A1*75%, what exactly does this mean ?

I suggest you use Barry's formula in a different cell, for example B1, and then use Copy, Paste Special, Values to paste the result back into A1.

Replies
2
Views
202
Replies
0
Views
335
Replies
1
Views
305
Replies
2
Views
520
Replies
2
Views
183

1,191,632
Messages
5,987,780
Members
440,110
Latest member
albertod8

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back