MIN-MAX trouble

**JoKnows** · 03-23-2013, 10:51 PM

One followup question.

Min and Max functions will return a "0" if the range is blank. Is there any way to NOT return the 0 if the range is blank? Currently, if I have something like this

Doctors Office 40%

The formula will return: $0-$0,40%-40%

I need it to return 40%-40%

Thanks

**FDibbins** · 03-24-2013, 01:03 AM

OK that wasnt what you asked for in post 12...

Originally Posted by JoKnows

One followup question.

Min and Max functions will return a "0" if the range is blank. Is there any way to NOT return the 0 if the range is blank? Currently, if I have something like this

Doctors Office 40%

The formula will return: $0-$0,40%-40%

I need it to return 40%-40%

Thanks

=if(sum(the-range-you-used-for-%)=0,"0%-0%",your-min/max-formula)&if(sum(the-range-you-used-for-$)=0,"$0-$0",","&your-min/max-formula)