ExcelBanter - Percentage of

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Percentage of (https://www.excelbanter.com/excel-worksheet-functions/143171-percentage.html)

tmaxwell

Percentage of

This should be easy.........I need to subtract 15% or 20%..etc from the list
price.

The list price is $1153.50 less 15% this formula is not close.
=F2-(1-D2)

JE McGimpsey

Percentage of

One way:

=F2*(1-D2)

In article ,
tmaxwell wrote:

This should be easy.........I need to subtract 15% or 20%..etc from the list
price.

The list price is $1153.50 less 15% this formula is not close.
=F2-(1-D2)

David Billigmeier

Percentage of

List price is in F2 and % is in D2?

=F2*(1-D2)

--
Regards,
Dave

"tmaxwell" wrote:

This should be easy.........I need to subtract 15% or 20%..etc from the list
price.

The list price is $1153.50 less 15% this formula is not close.
=F2-(1-D2)

All times are GMT +1. The time now is 04:05 AM.