Leave it Blank???

[n2music]

I have seen a lot of information on leaving a cell blank if one part of the formula is True or False. How would I leave the cell blank if my formula is neither true or false when all of the data needed to make the True or False determination is not available?

Thank you

[Pete_UK]

Something like this:

=IF(missing_data,"",your_formula)

where you have to supply an expression to represent missing_data. This might be something like OR(A2="",B2=""), but it all depends on your_formula - can you be a bit more explicit?

Hope this helps.

Pete

[n2music]

Yes, here is my formula in cell E19: =IF(AZ18>V19,V19+(AZ18>V19)-AZ18,(V19-AZ18)) so basically, as long as V19 remains blank, I want cell E19 to remain blank.

Thanks

[bonny24tycoon]

Why dont you try this

Please Login or Register  to view this content.

[n2music]

Perfect, Thanks so much.