Hi!
I have in a cell(K18) a formula that calculates time based on speed. The speed is found as the highest in the row K5 to K12. The speed again is calculated from info that is written in the cells J5 to J12, also J21 and C7.
I want the cell(K18) in which this formula is located to show blank cell, when there is no entries in the row J5 to J12. When there is entries somewhere in this row, it shall show the result. It works if I have only one cell, J5, in formula, but it does not work if I write the row J5:J12 instead. Then it shows #DIV/0!.
The problem is J5 in the (ISBLANK(J5)). When I try J5:J12 instead the cell is not blank, but it is blank when I write only J5.
I need help to solve this. On forehand I thank You for the time and effort.
Yours Roger in Norway
cell(K18) =IF(OR(ISBLANK(J5));"";(((J21*1000)/MAX($K$5:$K$12)/1440)+$C$7))
Bookmarks