Enter different valued in the same CELL and get SUM result

**hamid_v** · 11-24-2011, 02:04 AM

Hello ,

Please check the attachment file .

I do have the following columns
'Sell Rate' (F)
Sell Number ( G )
Total Sale (H ) >>>>>>>>>> Command =F*G

it works fine but there is a snag :
sometime we sell some of the products by discount which makes confusion because i have entered a fixed price in (F)

Please Advice me and give me a solution ,
And also please let me know if it`s possible to enter different value in (F) for example 10+20+10+20 And get the result in the same or different Cell .

**vlady** · 11-24-2011, 02:46 AM

Try this one
Computation for discount rates..

Please Login or Register  to view this content.

Attached is the sample.

**teylyn** · 11-24-2011, 04:06 AM

hamid_v, please post Excel files, not pictures. Nobody feels like re-typing your data to test a solution.

vlady, please post a description and the formula in the post, don't just attach a file and force people to open an attachment to check a suggestion.

**teylyn** · 11-24-2011, 04:09 AM

hamid_v,

unless you enter how many items were sold at a discounted rate, or what the discount rate is for the whole transaction, there is no way Excel can show that result.