IF Statement within a Text Box

[#1]

Hi,

I've used the below formula in a textbox

=If(ActivityType='RiskProgressRAG' and Qty = 'Green','Green',If(ActivityType='RiskProgressRAG' and Qty = 'Red', 'Red','Blank'))

I'm hoping that this will give me the Text Green, Red or Blank. However it only works when i select the ActivityType, otherwise it always returns blank. Is there a formula that will give me the result without having to make the selection within the ActivityType Field.

Many Thanks

B

[hannan_t]

Where you need the colour green you have ti mention the RGB Value of green

=If(ActivityType='RiskProgressRAG' and Qty = 'Green', RGB(0,127,0), If(ActivityType='RiskProgressRAG' and Qty = 'Red', RGB(255,0,0), RGB(255,255,255))

[tresesco · Accepted solution]

Try like:

=If(Max( If(ActivityType='RiskProgressRAG' and Qty = 'Green',1,0))=1, 'Geen'),

If(Max( If(ActivityType='RiskProgressRAG' and Qty = 'Red',1,0))=1, 'Red'), 'Blank'))

[#4]

Thankyou Very Much