Boolean is Required Error

[samimichaels]

I am trying to create a fomula on a sub-total. When I try the first line alone it runs fine. But then I start putting in the "or" data, I keep getting an error message that a boolean is required after the "then". Why? What am I doing wrong?

if {#RTotal0} > "1" then "$.50" or
if {#RTotal0} > "99" then "$1.00"

 

[kdk13]

Try 'else' instead of 'or'.

 

[Ngolem]

"OR" along with "NOT" and "AND" require boolean expressions

if {#RTotal0} > "1" then "$.50" does not evaluate to a boolean yes / no

As pointed out replacing "or" with "else" will make your expression work

Jim Broadbent