Home > Software design >  Google Sheet how to concat and calculate
Google Sheet how to concat and calculate

Time:12-17

I have created a sheet that generate random math questions. I'm having issue create automated answers. enter image description here

Alternatively, without a helper column, the formula would be-

=query(,"Select "&A1&B1&C1&" label "&A1&B1&C1&" ''",0)
  • Related