If statement

[#1]

Hi -

I am working with a table where i need to format in Bold specific rows. I am trying to achieve this using if statement within the 'Text Format' properties.

if(Consolidated='Revenue','<b>',if(Consolidated='Cost of Goods Sold','<b>',if(Consolidated='Taxes','<b>', ' ' )))

For some reason this expression only highlights first row 'Revenue' and does not work the rest of the rest of the fields.

What am I doing wrong?

Please help

Thank you!

[#2]

Hi,

how many Revenues, etc. are there in the table?

Have you checked for typos?

Try encircling the error by copying that column as test versions using one if statement per column.

Ciao

Klaus

[shree909 · Accepted solution]

hi

try

if(Consolidated='Revenue','<b>') or

if(Consolidated='Cost of Goods Sold','<b>') or

if(Consolidated='Taxes','<b>','  ' )