LinkBack URL
About LinkBacks
I want cell D5 to show the minimum value of cells D29:T29. Some of the cells in D29 to T29 will have $0.00 values and others will have values. I tried the following formula and it gives me a $0.00 value in cell D5:
=IF(D29:T29>0,MIN(D29:T29)))
I want cell D5 to show the minimum value of cells D29:T29. Some of the cells in D29 to T29 will have $0.00 values and others will have values. I tried the following formula and it gives me a $0.00 value in cell D5:
=IF(D29:T29>0,MIN(D29:T29)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks