from weights to volumes

Occasional Visitor

Hi people  

 

Does anyone now which formula I need to solve the following issue:

I have a list of weights in grams, I want to automatically attach a volume in uL to that. This is based on a schedule: between 19-20.9 gram it must be 100 uL. Between 21 and 22.9 it must be 110 uL. Between 23 and 24,9 is must be 120 uL. So when I add a new weight in grams, I want the program to give me the right volume in uL. 

 

Kind regards,

 

Nikki 

1 Reply

Use Conditional IFS formula, Range should be changed 19-20.99,21-22.99 & 23-24.99 so on
=IFS(D1<=20.99,100,D1<=22.99,110,D1<=24.99,120,D1>25,130,TRUE,0)