Multiple Expressions in One Column? :/

[Alejandra_Petro]

Hello,

I will really appreciate some help with this one.

I got my table with a column for loads, weights, rates and earnings. Some of those rates are multiplied by load (1load x $200 = $200) meanwhile some of them are multiplied by weight (22.5t x $200 = $4,500). is there any way to get these calculations in just one column?, as far as I know you are allowed to write one expression per column so I can not find the best way to do it. Does someone has any suggestions?

[EIG]

Hi,
You can use an IFS statement. https://help.appsheet.com/articles/2355961-ifs
Your formula would go something like this:

=IFS(ISNOTBLANK([Load]), [Load] * [Rate], ISNOTBLANK([Weight]), [Weight] * [Rate])