Skip to Content
0
Former Member
Feb 27, 2008 at 03:16 PM

How to write Boolean function (If Then Else)?

22 Views

Hi all,

I have a logic to write in the query. It is:

If (A = 0 and B = 0)

Then 0

Else

If (A = 0 and B > 0)

Then 100

Else

A/B (we want to show %)

How to use boolean function to write this Netted If Else statement? Thank you in advance!