May I please have your help with the following Excel formula, which is in cell DY11. The intention, is to achieve either a blank cell, one with zero (0.00) value or an actual two decimal number value. IF(ISBLANK(DX11),"",IF(DX11=0,0,DX11)) Cell DX11, apart from containing a formula, is blank, but the formula returns a zero (0.00) value in cell DY11.
Thanks VoG™, I guessed you'd be the one to reply. However, I'm still not achieving my aim. The formula you suggest, produces either a blank or an actual value cell, but not a cell with a zero (0.00) value. Cell DX11, should either have a blank, zero or actual value.
Cell DX11 contains the following formula: IF(DW11="","",IF(DW11>0,ROUNDDOWN(DW11,0)*20%,0)). Cell DX11 will remain blank, unless data is generated. Conversely, if a negative or positive value is generated in DW11, then in cell DX11 either a zero value will ensue if negative, or an actual value if positive. A bit verbose, but I hope the explanation is understandable? I've tried the formula: IF(DX11="","",IF(DX11=0,0,DX11)) in cell DY11, but it remains blank if DX11 has a zero value.
Something rather weird is happening! With the intention of seeking your permission to e-mail you an extract of the offending spreadsheet, I copied part of it to fresh one. However, while your suggested formula didn't work on the original sheet, it did on the fresh one. I can't understand it, but I'll do my utmost to find out and come back to you.
Thank you for your help yesterday VoG™. However, I never did get to the bottom of the anomaly between the two spreadsheets. In the end, I solved my problem by rethinking my requirements, and tweaking the formula 'IF(DX11="","",IF(DX11=0,0,DX11))' you suggested, but instead of working off cell DX11, used DT11 instead. Without seeing the spreadsheet this will probably sound strange to you but, let me say, it works! It's great being able share and solve problems on this forum.
This thread is now locked and can not be replied to.