Custom Format

B

bpkaufman

[<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.
 
R

RichardSchollar

Hi

I seem to get it to work with:

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

Hope this helps!

Richard
 
B

bpkaufman

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 said:
Hi

I seem to get it to work with:

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

Hope this helps!

Richard



[<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.
Click to expand...
Click to expand...
 
Top