[<0.1]"NMF"; 0.0

returns -NMF if it is negative though I just want NMF if it is <.01

Thanks in advance for any help.

Hi

I seem to get it to work with:

[<=0]General;[<0.1]"NMF";General

Hope this helps!

Richard



wrote:
[<0.1]"NMF"; 0.0

returns -NMF if it is negative though I just want NMF if it is <.01

Thanks in advance for any help.

Richard,

Thanks for the help. Your function did not work for me. let me
restate my original questions as it was somewhat off and not complete.

I need to have NMF show when the cell is less than 0.1

I have this function in the cell as well:

IF(ISERROR((M71/'All Country'!$M$14)*100),"NMF",((M71/'All
Country'!$M$14)*100))

Thanks,

Ben
RichardSchollar wrote:
Hi

I seem to get it to work with:

[<=0]General;[<0.1]"NMF";General

Hope this helps!

Richard



wrote:
[<0.1]"NMF"; 0.0

returns -NMF if it is negative though I just want NMF if it is <.01

Thanks in advance for any help.