i need formula to calculate with requirement as below :
1 carton = 16 box
1 box = 5 pump
1 pump = 3 cup
example 2cup + 1cup = 1 pump
CA= cartoon, B=box, P=pump, CU=cup
currently my formula is only work in excel , when upload to google , open with google sheet , it become error.
https://drive.google.com/file/d/1JBI...ew?usp=sharing
Pls help, Reputation sure will give to u. thanks.
Bookmarks