IF function: Conditionally multiplying a value

Solved
Report
Posts
1
Registration date
Thursday December 16, 2021
Status
Member
Last seen
December 16, 2021
-
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
-
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

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
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