Sep 24 2021 12:49 PM
I have 2 cells, cell 1 will have 1 of 3 different numbers in it ($35, $45 or $50). I would like a cell 2 to populate 15 if cell 1 is $35, 20 if cell 1 is $45 or 25 if cell 1 is $50. Is there a formula that will do this? Please help as I have tried everything I can think of....
Thank you in advance :)
Sep 24 2021 12:55 PM
Let's say the first cell is A2.
In the other cell, enter the formula
=IF(A2="","",IF(A2=35,15,A2-25))
Sep 24 2021 01:15 PM
Sep 24 2021 02:05 PM
Just so that you may have choice!
= SWITCH(list,
35, 15,
45, 20,
50, 25,
"")
= IFERROR(
LOOKUP(list, {35,15;45,20;50,25}),
"")
= XLOOKUP(list, numbers, output,"" )
Of these only the 2nd works with Excel versions older than 2019.
Sep 25 2021 02:39 PM