Conditional Formula, Driving me mad...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to get a formula set up that is refrencing 3 cells in a spreadsheet. It is in an insurance policy tracking spreadsheet. For example... If cell A1 = YES, then cell B1 must equal the appropriate amount of coverage, (in this case 1,000,000), and cell C1 must equal less than 355 (today's date - policy exp. date). If all these statements are true it should return a value of COMPLIANT. If any of those are false it should return a value of NON-COMPLIANT.

The kicker is, if cell A1 = NO, then B1 & C1 are irrelevant because they do not need the coverage and it should return a value of COMPLIANT.

I can make the first part work fine with just a simple IF(AND statment. It's the second part that I am having the trouble with. If any one can help that would be great!!!

Thanks
JP
 
Hi JP
try
=IF(OR(AND(A1="Yes",B1=1000000,C1<=355),A1="No")
this can be simplified to
=IF(OR(AND(B1=1000000,C1<=355),A1="No")
if A1 can either be 'Yes' or 'No'

HTH
Frank
 
Back
Top