Can some please help me with this.
=IF(A3="","",IF(IFERROR(DK28,0,),IF(BC3=0,DK28,DK3/MAX(DK2:DK26))*FV24))
Im wanting it to return a 0 if cell DK28 is a #DIV/0 error.
thanks,
Can some please help me with this.
=IF(A3="","",IF(IFERROR(DK28,0,),IF(BC3=0,DK28,DK3/MAX(DK2:DK26))*FV24))
Im wanting it to return a 0 if cell DK28 is a #DIV/0 error.
thanks,
Its OK, I worked it out.
=IF(A3="","",IF(ISERROR(DK28),0,IF(BC3=0,DK28,DK3/MAX(DK2:DK27))*FV24))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks