Help with a formula 2

[cyreports]

I need help with a formula.

I would like to set ado.rvufee equal to 20% of its normal value if {ado.Mod1}, {ado.Mod2},{ado.Mod3} or {ado.Mod4} equals 80.

 

[lbass]

if
{ado.Mod1} = 80 or
{ado.Mod2} = 80 or
{ado.Mod3} = 80 or
{ado.Mod4} = 80 then
.2*{ado.rvufee} else
{ado.rvufee}

-LB

 

[Turkbear]

Hi,
If I understand the issue then try

If
(
{ado.Mod1} = 80
OR
{ado.Mod2} = 80
OR
{ado.Mod3} = 80
OR
 {ado.Mod4} = 80
)
Then
ado.rvufee * .20
ELSE
ado.rvufee

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[cyreports]

Wow, thank you for the speedy response. It tells me a string is required here and highlights the first 80. Should I enclose it in ' ' or " " ?

 

[lbass]

Enclose all the 80's in either single or double quotes.

-LB

 

[cyreports]

Thank you both!