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 555
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
"Sorry, this feature isn't available ... " how to fix this?
Anonymous User -
heclam -

3 responses
How to disable Fn keys
HENRY -
ZiaRahman -

30 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response