#1
|
||||
|
||||
Excel formula from looking the base date and convert into desire result
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 |
#2
|
|||
|
|||
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 |