Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
2 Nesting questions | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |