nested if statement

Wandy

New member
i have this issue
if (C2="annual check") {
if (D2<TODAY() print expired;
else if (D2<=TODAY()+7 print expiring soon;
else print ok;
} else if (C2="monthly check") {
if (D2<TODAY() print expired;
else if (D2<=TODAY()+7 print expiring soon;
else print ok;
}

i can work fine with "annual check" alone
but when combining with "monthly check" i have no clue how to write it.
i hope someone can help on this. Thanks in advance.
 

Online statistics

Members online
1
Guests online
141
Total visitors
142

Forum statistics

Threads
462
Messages
2,053
Members
2,931
Latest member
Thulasiani
Back
Top