ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   formula help (https://www.excelbanter.com/excel-worksheet-functions/109234-formula-help.html)

Paula

formula help
 
I need help with a formula
I have 10 days (A1) X RATE OF $800.00 PER DAY (B1) LESS 10% DISCOUNT (C1)
=D1.

I CAN GET THE A1*B1 BUT HOW DO I GET THE LESS 10% IN $$$ AND THEN GET A
TOTAL. I HAVE TRIED BUT CAN'T SEEM TO GET IT.

THANKS

Don Guillett

formula help
 
You should ALWAYS post what you have done for comments and suggestions.
Have you tried=(a1*b1)*.90

--
Don Guillett
SalesAid Software

"Paula" wrote in message
...
I need help with a formula
I have 10 days (A1) X RATE OF $800.00 PER DAY (B1) LESS 10% DISCOUNT (C1)
=D1.

I CAN GET THE A1*B1 BUT HOW DO I GET THE LESS 10% IN $$$ AND THEN GET A
TOTAL. I HAVE TRIED BUT CAN'T SEEM TO GET IT.

THANKS




Toppers

formula help
 
See reply to previous posting

=a1*b1*(1-c1)

"Paula" wrote:

I need help with a formula
I have 10 days (A1) X RATE OF $800.00 PER DAY (B1) LESS 10% DISCOUNT (C1)
=D1.

I CAN GET THE A1*B1 BUT HOW DO I GET THE LESS 10% IN $$$ AND THEN GET A
TOTAL. I HAVE TRIED BUT CAN'T SEEM TO GET IT.

THANKS



All times are GMT +1. The time now is 03:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com