Custom Format icon of infinity values

Hi FSyed,

Your rules are set to show values less than 0.85 with the red icon. Green icon will be visible for values more than 0.99. So can you please eloborate why you want 0 as green and not red?

I can do this in excel like this:

This is the excel script:

=IF(G4<0.85,"RED",IF(AND(G4>=0.85,G4<1),"AMBER","GREEN"))

Thanks, Shaurya for your swift response

As per the rule in this row, Reserves has no Budget(target) but we have achieved and get the positive values but when we calculate the percentage  0/776 = 0.00   (Should show positive or Green)  hope it make sense now

Thanks again for your help

Kind regards,

Farhan

I think the issue is, how to get round of showing infinity as something other than “Infinity”. 

Showing as zero won’t work with the below logic since zero is <0.85 so will show as Red.

Thanks as this row hasn't got any Target hence has some Savings (Outurn) i.e. +776  made some profit 

The user say its one of exceptional if the %achieved is 0 or infinity should be green icon

I think i have done by adding an additional rule its working at this time but don't this its the correct way to do that

Thanks Shaurya again