Multiple IFS for calculations

rachel1073
edited 12/09/19 in Formulas and Functions

Hi,

 

I have no problem doing this in Google Sheets but I'm not sure how to do this in Smartsheet.

I have columns that contain THC and CBD content, measured in a number of different ways, including percentages, mg, percentage ranges, etc., but they're always consistent units of measurement across the row. 

I need to calculate the following:

THC>CBD = THC

CBD>THC=CBD

Equal THC/CBD=THC

Blank=Leave blank

I'm not able to get all of these IF statements to work together, I get a number of errors depending on how I structure the formula.

 

Any suggestions?



Thank you,

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!