IF function: Conditionally multiplying a value

Solved
BeastNZ Posts 1 Registration date Thursday December 16, 2021 Status Member Last seen December 16, 2021 - Updated on Dec 20, 2021 at 12:29 PM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Dec 20, 2021 at 12:27 PM
Ok so I am trying to create a formula that would use a different calculation based on an answer. So when I get the number 2 in a cell then the data used would be calculated based on *0.242. When the number in that same cell is 3 use *.445. does this make sense??. Its way above my level of experience.

1 reply

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Dec 20, 2021 at 12:27 PM
Hi BeastNZ,

For that you would want to use an IF function.

Lets say the number 2 or 3 is in cell A1 and the value you want to multiply is in B1,then the formula would look like:
=IF(A1=2,B1*0.242,IF(A1=3,B1*0.445,""))

Best regards,
Trowa
0