Previous Topic Next Topic

Nested if statment using

Closed
confused54 - Mar 5, 2010 at 04:20 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 5, 2010 at 06:00 PM
Hello,

Im new to nested IF statments and am trying to get a possible of 3 results based on the DOB column,

below is what I thought would work (along with the required results) and its not, any suggestions?

=IF(E3 >= DATEVALUE("01.01.1971"), "5", IF(E3 >= DATEVALUE("01.01.1964"), "3", IF(E3 <= DATEVALUE("01.01.1963"), "2")))

im completly stuck......
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 5, 2010 at 05:35 PM
Not sure what is the issue ? Could you explain more what problem you have ?
0
confused 54
Mar 5, 2010 at 05:50 PM
i have a spreadsheet containing DOB (column F) (formated dd.mm.yyyy) i need to use the DOB to determin how often an individual will be seen "frequency" (column J) i have created this formula to determine how often , either every 2, 3, or 5
=IF(F3>=DATEVALUE("01.01.1971"),"5",IF(F3>=DATEVALUE("01.01.1964"),"3",IF(F3<=DATEVALUE("01.01.1963"),"2")))

it is not working????

in addition i have a column "last" (date, same format)(column K) and a "due" (column L) that i want to use the calculation in column J to determine the next visit date, see formula:

=IF(J2="5",K2+1825,IF(J2="3",K2+1095,IF(J2="2",K2+730)))

it is not working either????
any and all help is GREAT!
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766 > confused 54
Mar 5, 2010 at 06:00 PM
One of the obvious question is that does your system recognize this format (mm.dd.yyyy)?
Try in a cell =datevalue("10.10.2010") see if you get a number or error. I think it is the format issue. As you might know, in excel if a column looks like a date, excel may or may not treat it as a date. So see if datevalue even works or you have to use mm/dd/yyyy format
0

Similar discussions

Nested IF functions using time values
SharkMerry -
Harshada Chaudhari -

5 responses
using nested if to blank out adjacent cells
WILLYB -
mubashir aziz -

3 responses