Zero value is getting displayed in brackets? Could you please help to solve this, Since I have written a condition like, If (value=0, Green, Red)

[#1]

[sasiparupudi1]

try

if(round(value)='0',green(),red())

[#3]

Okay cool. Thank you

[jagan]

Hi,

Ceil() will return the next integer, if you are ok with that then you can use.  For 179999.997 it will give 180000.

You can also try Round()

Hope this helps you.

Regards,

Jagan.

[#5]

Thank you Sasidhar. That too worked

[sasiparupudi1]

Great,please close this thread if you got your answer

[#7]

yeah I got the Answer, Thank you everyone for your prompt reply