Formula equation
You have a circular reference. you can not put the reference to d15 when the
formula is in d15. thry this in D15
=IF(OR(COUNTBLANK(D17:D20)0),"",MIN(D17:D20))
It returns blank unless there are numbers in each of the cells D17:D20 and
the minimum of the range if there are 4 numbers.
Regards
Peter
" wrote:
My problem is I got this formula, which achieve the results I want
apart from one solution. The equation is: -
=IF(OR(D15="",COUNTBLANK(D17:D20)0),"",IF(COUNTIF (D17:D20,D15)=4,D15,MIN(DÂ*17:D20)))
The solution that I am looking for if any number is selected out of
D17:D20 it should display the min value in D15, but the equation you
must select
all 4 cells from D17:D20 for the min value to display in D15.
Anyone there that can help me?
many thanks
ims
|