Skip to Content
0
Former Member
Feb 05, 2009 at 09:40 PM

applying the "if" function with multiple criteria

25 Views

Hi,

wanted to know how I can, within the same formula, apply the "if" function to two criteria.

For example:

criteria 1

if {red.field}="okay"

then 200

else -200

criteria 2

if {blue.field}="okay"

then 200

else -200

I want this formula to find all the "okay" in the red.field and the blue.field, and apply 200 to all the "okay," and -200 to all the rest.

please help,

thank you!

Frank