IF AND IF THEN ELSE END IF - UGH it's not working!

[MaryCann]

The formula cannot be this difficult!  And I don't want my boss to know I can't figure it out.  So, you folks!  What is wrong with the below formula?

Supposedly it's a Malformed If Statement...

[ShankerV · Accepted solution]

Hi @MaryCann 

You have used 2 IF, you need to use only 1 IF.

Many thanks

Shaker V

[Luke_C]

Hi @MaryCann change your AND IF to just AND

[IraWatt]

Hey @MaryCann,

You don't need the second IF statement should just start:

IF [Prescription End Date] >= DateTimeTodya() and [Client.....

[MaryCann]

OMG!  Thank you @ShankerV !

[ShankerV]

Hi @MaryCann 

IF (condition 1 AND condition 2)
then
else
endif

Many thanks

Shanker V

[ShankerV]

@MaryCann 

Welcome, happy to help!!!

Many thanks

Shanker V