formula to calculate percentage

[percenthelp]

[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]

 

[barry houdini]

Try

=A1*75%

 

[percenthelp]

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]

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

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

 

[Gerald Higgins]

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.