Help reg. Formulae In Ms.Excel

[navino87]

Hi guys...

I am bit confused in creating formulae for the following calcullation... Please help me out...

This is regarding share trading:

For Cash Trades : Let us say Trade Amount is 30,000.00

Brokerage = 30000 * 0.75 / 100 = 225.00

If Brokerage is less than 25.00 then 25.00 is charged.

For Margin Trade : Let us say Buy Amount is 30,000.00 & Sell Amount is 31,000.00

Buy Brokerage = 30000 * 0.05 / 100 = 15.00

If Brokerage is less than 15.00 then 15.00 is charged.

Formulae : =IF(AND(D3="Cash"),((C3*E3)*0.75/100),(C3*E3)*0.05/100)

This formulae is till the calculation work... I want this formulai to work for the highlighted statement.
i.e.
in case 1:
If the result is less than 25 then the cell should contain 25.
in case 2:
If the result is less than 15 then the cell should contain 15.


Please help me out regarding this...

Regards,.

 

[Ramakrishnan]

Please try the "IF" statment on the column next to the one containing your formula.

 

[sakumar79]

If Cash Trade, Brokerage is Min of 25 and 0.75% amount; else Brokerage is Min of 15 and .05%

IF(D3="Cash",MIN(25,.75/100*D2),MIN(15,.05*D2/100))

where D2 represents the cell where Trade Amount is specified and D3 is the cell which says Cash or Margin...

Arun

 

[navino87]

@ Ramakrishnan
Even tried it out... Bt it does't work...

If Cash Trade, Brokerage is Min of 25 and 0.75% amount; else Brokerage is Min of 15 and .05%

IF(D3="Cash",MIN(25,.75/100*D2),MIN(15,.05*D2/100))

where D2 represents the cell where Trade Amount is specified and D3 is the cell which says Cash or Margin...

Arun

Thanks a lot man... I hav tried it out, n tis does't seams to work... I am not getting the min value if the amount is less than the min value...

^^^
@ sakumar79
Figured out the mistake man... changing the min keywoard with max has worked...

Any way thanks a lot...

 

[sakumar79]

Oops, sorry about that....

Arun