Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
127
Views
Topic starter
Hi Expert,
i have a problem excel as per below:
there is a condition
3 x G701 = 1 x 601
If there are 6 x G701 = 2 x F601
there are 7 x G701 threfore should be 2 x F601
but i dont know how to apply formula?
thanks for promp reply
Posted : 09/05/2017 10:05 am
Maybe first make a kind of conversion table and then with Vlookup search for the right multiplier?
Posted : 11/05/2017 7:32 am
