Where do the brackets go in this formula? 1

[andywing]

I'm trying to format a font to go red if criteria are met but I've got lost with this one

Does the following formula make sense to anybody who can see my mistake?

I think I need brackets somewhere but I don't really know!

if {databasefield1} in [7, 8, 9, 10, 11]
and {databasefield2} > 90 then red
or
if {databasefield1} in [1, 2, 3, 4, 5, 6]
and {databasefield2} > 55 then red
else defaultattribute

Andy Wing
Local Government - Systems Officer
England

 

[synapsevampire]

Try:

if
(
{databasefield1} in [7, 8, 9, 10, 11]
and {databasefield2} > 90
)
or
(
{databasefield1} in [1, 2, 3, 4, 5, 6]
and {databasefield2} > 55
)
then
crred
else
crblack

-k

 

[andywing]

That's it! Works a treat, many thanks!

Andy Wing
Local Government - Systems Officer
England