Need help with formula

zachluke · #1 03-12-2014, 10:41 AM

Having trouble with a formula please help.
For an entire spreadsheet: if cells B1 thru K1 have prices in it than I want column A1 to read YES. If cells B1 thru K1 have no data in them then I want column A1 to read NO.
Any help would be appreciated. Thanks!

gebobs · #2 03-13-2014, 10:21 AM

Is it a binary? That is, if there are prices in one of the cells, then there are prices in all of them? Or can some cells have prices and others be blank?

zachluke · #3 03-13-2014, 11:07 AM

Thanks for the help gebob. Some of the cells will have prices in them, others may not. Those rows I want to read YES.
The rows without any prices in any of the cells, I want to read NO. Hope this helps! Thanks!

gebobs · #4 03-13-2014, 11:15 AM

In A2... =IF(SUM(B2:K2)>0,"Yes","No")

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need Help w/Formula	OSCAR MARTINEZ	Excel	1	09-28-2013 05:39 AM
IF formula	MARK SMITH	Excel	2	04-04-2013 01:58 PM
help with a look up or if formula	beb1227	Excel	3	12-31-2011 01:08 PM
Help with Formula	Corca	Excel	6	02-22-2010 09:40 PM
If formula	sixhobbits	Excel	1	10-02-2009 08:02 AM