Previous Topic Next Topic

IF function: Conditionally multiplying a value

Solved/Closed
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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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.
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Dell laptop FN key is not working
adibah -
Artur -

93 responses
USB:\ is not accessible. Incorrect Function.
rickitikz -
Amar Yadav -

7 responses
Excel function question
1234ah -
ac3mark -

3 responses