Im trying to create a formula that would charge a % to a column depending on another column
Ex. If Column I2 =”Finance” then Multiply Column R2 to K2
OR
If Column I2 =”No” then Multiply Column R2 to F2
=ifs(I2″Financing”,K2* 0.04,I2″No”,F2* 0.04)
=ifs(I2="Financing", K2*R2, I2="No", F2*R2)