Excel formula from looking the base date and convert into desire result

PRADEEPB270 · #1 02-16-2013, 03:46 AM

I have an excel file.I want to solve the category condition from an excel formula.In this file,G3 will be my base date and I want the excel formula in colum no.I i.e.Category.For this,look the base date i.e.G3 and compare to column F i.e.Date Column of each material code.

For more clarification,please refer the attach file

Regards

Catalin.B · #2 02-17-2013, 03:11 AM

You can use this formula, copied down as necessary:
=IF(INT(($G$3-F5)/365,25)>=4;"> 4 Years";"> "&INT(($G$3-F5)/365,25)&" Years < "&CEILING(($G$3-F5)/365,25;1)&" Years")

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert Formula Result to Static Text	MYGS	Excel	16	01-21-2013 08:18 AM
If formula result is negative then display text	oxicottin	Excel	3	12-03-2012 02:12 AM
IF formula returns wrong result	mashley	Excel	3	09-07-2012 07:03 AM
Can I create a formula that will show result in the same cell and let me copy it down	CranstC	Excel	1	02-11-2012 01:29 AM
Calculate formula base of list menu	rkeles	Excel	4	09-22-2010 12:38 AM