In: Computer Science
| value | unit | 
 spherical volume (in^3)  | 
spherical volume (m^3) | 
 spherical volume (gallons^3)  | 
| x | in | ? | ? | ? | 
So I'm being assigned the task of creating a custom conversion table that utilizes logical statements for the purpose of converting the given values from the input units into the other listed units within excel. I've tried a few, however, I don't know how to list multiple statements. For example, if B2, the user writes "m", then each of the corresponding spherical volume units is different.
If I can get help with the first spherical volume unit, I can do the rest from there...