Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
56
Views
Topic starter
Current formula i am having is below.
=ROUND(IF(AND(B6="E",C6="BT"),SUM(G6,I6)*5%,SUM(G6,I6)*3%),0)
Now i have a new condition. ie
| A | B | C | D | E | F | G (E*F) | H | I(E*H) | J SUM(1% OF G OR 50*D WHICHEVER IS HIGHER)+(1% OF I OR 50*D WHICHEVER IS HIGHER) |
| O | 2 | 6000 | 3 | 18000 | 5 | 30000 | 480 | ||
| O | 1 | 3000 | 1 | 3000 | 2 | 6000 | 110 |
I need this criteria to be included in the above formula.
Posted : 02/04/2018 1:57 pm
Hi Sajil,
Can you provide a sample workbook with data and formulae? It's not really clear what it is you are after.
Where is the ROUND formula currently ?
What criteria do you want included and into what? Do you want the SUM included in the ROUND somehow?
Regards
Phil
Posted : 05/04/2018 2:41 am
