IF(ISBLANK(Cell#," ",(Cell#)) Question

[coffmant80]

Good evening thanks for the add, I'm pretty new to using more advance formulas & VBA.

My question is as follows,

How would you calculate a formula to ignore the blank cell (or a hidden row* preferably), Ex. you have a cell further down at row 15 you would like to calculate.

Gray are is a time conversion of mins which is being used in the current formula = P105

I'm using the following formulas currently;

M11 O11 Q11
15 / =IF(ISBLANK(M11)," ",(Q9)) / =IF(ISBLANK(M11)," ",O11+P105)

Thank you in advance for the help also.

 

[Joe4]

Welcome to the Board!

Any cell that has any formula or the value " " (single space) in it is NOT blank.
Better to return an empty string ("") instead of a single space (" ").

If you use the empty string, then you can just check the length of the value in the cell, i.e.

=IF(LEN(M11)=0,"",R9)

and

=IF(LEN(M11)=0,"",O11+P105)

 

[coffmant80]

Welcome to the Board!

Any cell that has any formula or the value " " (single space) in it is NOT blank.
Better to return an empty string ("") instead of a single space (" ").

If you use the empty string, then you can just check the length of the value in the cell, i.e.

=IF(LEN(M11)=0,"",R9)

and

=IF(LEN(M11)=0,"",O11+P105)

Thank you for the information,

That helped with the #value!

I have another question if it's possible,

Say we don't want to delete any rows, but we hide row 3 in the image. Is it possible to have a formula or VBA to ignore the hidden row and have the calculation continue at row 4?

Thank you again for your response.

 

[Joe4]

Thank you for the information,

That helped with the #value!

I have another question if it's possible,

Say we don't want to delete any rows, but we hide row 3 in the image. Is it possible to have a formula or VBA to ignore the hidden row and have the calculation continue at row 4?

View attachment 71871

Thank you again for your response.

That is a whole different, brand new question, and as such, should be posted in a new thread so it appears as a new unanswered question.

 

[coffmant80]

That is a whole different, brand new question, and as such, should be posted in a new thread so it appears as a new unanswered question.

Thank you for the information, I'll start a new thread sir