In excel, how do I make a column "YES"
Favorites|Homepage
Subscriptions | sitemap
HOME > > In excel, how do I make a column "YES"

In excel, how do I make a column "YES"

[From: ] [author: ] [Date: 11-12-23] [Hit: ]
......
I have a spreadsheet with multiple formulas. I want a final column to give me a yes or no base on one columns numbers being greater than 0 and the second columns numbers being less than 2000.

Cheers

-
Say Column A needs to be greater than 0 and Column B < 2000.
Place this in the column you want it to appear in:
=if(and(Ax > 0,Bx<2000),"YES","") {where x is the row number }

-
use if function
1
keywords: column,quot,excel,In,make,do,YES,how,In excel, how do I make a column "YES"
New
Hot
© 2008-2010 http://www.science-mathematics.com . Program by zplan cms. Theme by wukong .