round function with if function

[jrortiz2]

I have the following IF Function and need to be able to use the ROUND Function within this to round the figures to 0. can this be done?


IFERROR(IF(D14-E14=0,"Stable",D14-E14),IF(AND(E14="-",D14="-"),"NR",IF(D14="-","Gain","Dropped")))

attachment will show example

Thanks

[bentleybob]

Absolutely. Just be sure you round the right components:

Please Login or Register  to view this content.

is not the same as

Please Login or Register  to view this content.

[shg]

Duplicate post, thread closed.