I need to create a spreadsheet that can be changed from one unit to another. In a cell, the volume is listed next, the source unit again, at the last unit end, the result I need to find a way to code, in one line / cell, one way to calculate results is to use just that function For example:
"if (b2 =" millimeter "), and (c2 =" centimeter ", then (* this cell * = A 2/10), ELSE, IF (B2 - "...."), ... etc..
The teacher has indicated that I have more than one Calculation can not use EL.
Thank you for responding so quickly. (And (B2 = "Millimeter", c2 = "centimeter") = TRUE, A2/10, IF (and (b2 = "centimeter", c2 = "millimeter") = TRUE, A2 * 10, IF ((B2 = C2), "VALUES IDENTIC ...", "UNITS RECOGNIZED NO")))
No comments:
Post a Comment