CODEWITHSUNDEEP
excelexcel-formula
Donald Latta
Donald Latta

Reputation: 15

Not necessarily an IF function, but a condition being met

I am trying to get a cell in Excel to display one cell's value for a value of less than 20, and display a different cell's value if its results are 20 and greater. What function or formula would I use?

I want cell j23 to display value for cell b23 if value is under 20, or if value is 20 and greater to display cell value f23.

Upvotes: 0

Views: 50

Answers (1)

Forward Ed
Forward Ed

Reputation: 9874

IF function is made up of 3 parts

  • Logical
  • True result
  • False result (optional)

=IF(Logical,True Result, False Result)

=IF(B23<20,B23,F23)

IF by the title of your question you are trying to AVOID the if statement you have a couple of options. I must stress I am not a FAN of the VLOOKUP options and they are only presented as an option of not using IF.

You could make a little chart.

   A    |    B
  20    |  =F23

=IFERROR(VLOOKUP(B23,'somesheet'!$A$1:$B$1,2,1),B23)

Or you could go the indirect route using the following table:

=INDIRECT(IFERROR(VLOOKUP(B23,'somesheet'!$A$1:$B$1,2,1),"B23")

   A    |    B
  20    |  F23

'(the F23 is text)

My personal favourite of non if options:

=CHOOSE((B23<20)+1,J23,B23)

Upvotes: 3

Related Questions