Division by fixed number based upon choice

I would like to know how to build a simple spreadsheet based upon: 1) If 5ml then divide by 80 2) If 10ml then divide by 160 3) If 15ml then divide by 240 - I would like to have the person enter one ...

Formulas and Functions

Bill_Stuart
Jan 04, 2023
mathetes - Thank you for the spelling correction and I greatly appreciate your help~! I also came across the "data fixing element '$x$x' (for columns C & E)" in my quest for solutions to this query - Here is the link requested ->>> https://docs.google.com/spreadsheets/d/12UiC5ncBIqy2veOOvlmVgxSlwYGZPOUb/edit?usp=sharing&ouid=106533383641305730260&rtpof=true&sd=true . There are just three (3) fixed choices - As these products come in: A) 5ml B) 10ml C) 15ml sizes.

Bill_Stuart

Copper Contributor

Jan 04, 2023

mathetes - Thank you for the spelling correction and I greatly appreciate your help~! I also came across the "data fixing element '$x$x' (for columns C & E)" in my quest for solutions to this query - Here is the link requested ->>> https://docs.google.com/spreadsheets/d/12UiC5ncBIqy2veOOvlmVgxSlwYGZPOUb/edit?usp=sharing&ouid=106533383641305730260&rtpof=true&sd=true . There are just three (3) fixed choices - As these products come in: A) 5ml B) 10ml C) 15ml sizes.

Bill_Stuart

Copper Contributor

Jan 09, 2023

This is not a solution to this issue - This is a clarification that there are three (3) fixed amounts that need to be divided by three (3) fixed numbers - 5ml divided by 80 - 10ml divided by 160 - 15ml divided by 240

Forum Discussion

Division by fixed number based upon choice

Resources