Such as: input 1 represents "yuan / piece" in A1, 2 yuan /KG, then we can get the following formula: =if (A1=1, number (cell) * unit (Dan Yuanjian), weight * unit (cell)).

Posted by Theobald at January 02, 2017 - 3:51 PM

Such as: input 1 represents "yuan / piece" in A1, 2 yuan /KG, then we can get the following formula: =if (A1=1, number (cell) * unit (Dan Yuanjian), weight * unit (cell)).

Posted by Theobald at January 02, 2017 - 3:51 PM

1061.5164267 4.3 yuan / piece (list) =4.3*6

661.26828482 yuan /KG (list) =2*2848

If I choose yuan / piece, amount calculation unit * number

If you choose /KG if I list, the amount is calculated weight * unit

How to write a program that determine the amount of????

Started by Beata at December 28, 2016 - 2:52 PM