PDA

View Full Version : Solved: Formula help



austenr
08-10-2010, 07:23 AM
What is the correct syntax for this:

=if(Age>65 and SPAge < 65,"Split Coverage","")

GTO
08-10-2010, 07:53 AM
Hi Austin,

I believe its:

=IF(AND(Age>65,SPAge<65),"Split Coverage","")

Have a great day,

Mark

austenr
08-10-2010, 07:57 AM
Thanks Mark. good to go.