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,



1 Reply

Use Conditional IFS formula, Range should be changed 19-20.99,21-22.99 & 23-24.99 so on