logo
Tags down

shadow

How can I remove/hide formula if cell is blank?


By : Sena
Date : September 14 2020, 07:00 PM
Hope this helps You cannot use =IFERROR() in this case since the =MAX() function will return 0 when both cells are empty, instead of returning an error.
Some of the possible solutions:
code :


Share : facebook icon twitter icon

How can I remove blank line breaks from an excel cell with VB or a formula?


By : user1788321
Date : March 29 2020, 07:55 AM
I wish this helpful for you Substitute in a cell for linefeed seems to work - =Substitute(A1, CHAR(10), "")

Excel: Leave formula cell blank when input cell is blank


By : Piervit
Date : March 29 2020, 07:55 AM
I wish this helpful for you I have used a formula to create a point system for my class. My formula is below, and it works great except that when c10 is blank, the score still shows "10" when I'd like it to be blank as well. Could anyone help me edit this formula to fix that tiny error? I can't seem to figure it out. , replace "," to ";". You get:
code :
=IF(C10<6.99:10:IF(AND(C10<=7.99:c10>=7):9:IF(AND(C10<=8.99:c10>=8):8:IF(AND(C10<=9.99:c10>=9):7:IF(AND(C10<=10.99:c10>=10):6:IF(AND(C10<=11.99:c10>=11):5:IF(AND(C10<=12.99:c10>=12):4:IF(AND(C10<=13.99:c10>=13):3:IF(AND(C10<=14.99:c10>=14):2:IF(AND(C10<=15.99:c10>=15):1:IF(AND(C10>=A10:C16<=100):0)))))))))))

Hide a column if corresponding cell "is blank"/"formula is null" upon sheet's activation


By : Anubhav Modi
Date : March 29 2020, 07:55 AM
I hope this helps you . I am new to VBAing but have a small amount of javascript knowledge and hoping for a bit of guidance/help as I can't seem to get the code working. There's probably some glaring mistakes so thanks for the patience. , You have three errors in your code:
code :
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
    Dim i As Integer

    If Sh.Name = "FSM" Then
        For i = 2 To 30
            Columns(i).EntireColumn.Hidden = IsEmpty(Cells(2, i).value)
        Next i
    End If

End Sub

In Excel, if cell is blank OR formula result is 0, then how to show blank cell instead of #VALUE! error?


By : souguite abdoulkerim
Date : March 29 2020, 07:55 AM
this one helps. I am trying to create a table which plans for the future. So, cells containing a future calculation are going to be blank. They also might be 0. In either case, I want to show a blank. Instead, I get #VALUE! error. I don't want to see that error. , I think this may be what you want:
code :
=IF(L7*D18=0,"",L7*D18)
=IFERROR(IF(L7*D18=0,"",L7*D18),"")

Returning a blank cell if another is blank with formula already present in Excel


By : user2427798
Date : March 29 2020, 07:55 AM
Hope that helps Managed through lots of trial and error to solve it myself. to all those that posted. Here was what I came up with which seems to work well:
code :
=IF(SUM(P8:X8)>0,SUM(Y7-AA7), IF(SUM(E8:M8)>0,SUM(N7-O7),""))
shadow
Privacy Policy - Terms - Contact Us © 35dp-dentalpractice.co.uk