开发者

Excel spreadsheed populate cell based on value of another cell

I have a excel spre开发者_运维百科adsheet that contains a bunch of columns. My first column contains values of mpg(about 300 entries of miles per gallon). What I want to do is populate another column based on whether the value of the first cell is greater than or less than 23.5

So basically it looks like this:

**A**    **B**
 10 
 15
 29
 14
 32
 24

I want column B to be populated depending on if the corresponding cell (eg. A1 > 24.5 so populate B with yes) is greater than 24.5 with yes or no.

Is there a simple function I can use to do it on all the values? Please do provide detailed instructions since I hardly use excel and I'm lost on this past.


Type =IF(A2 > 23.5,"yes","no") into B2. Then double-click the bottom-right corner of the cell (the little box) to fill the rest of the cells.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜