Excel question! How to use IF function with a '

问题:

I am looking for a formula in excel that will make a number appear in a cell, if ANOTHER cells number is under 200.

So for example

If column A1 has the number 3 in it, and Column B1 has the number 198 in it, then Column C should have a formula that automatically puts the number '3' from A1 in it, based on the fact that column B has a number under 200.

So, I basically want a formula in the C column that says 'If B is less than 200, display A in C column

Please help!

FYI I am using this formula, and it is returning a 0, but not displaying the number in the cell when over 200 : =IF(N3=">200",L3,0)

回答1:

In A1, I've put the value 3.
In B1, I've put the value 198.
In C1, I've put the formula =IF(B1<200;A1), I see value 3.