Google Sheets Formula Parse error with IF statement that contains modulus and floors
=IF(E48>0,FLOOR(E48/64)*U48+FLOOR((E48%64)/8)*V48+FLOOR((E48%64)%8)*W48,0) This is in google sheets and this formula is creating a parse error. I am needing fresh eyes to take a look at the formula. Context of the formula: The formula is to help combine prices for items. E48 is the amount of items needed. U48 is the price of the largest bulk option, […]
Unable to write Query function in Google Sheets to compare both a cell value and date
The following query is breaking for me in Google sheets, and I can’t determine what I’m doing wrong: