Search results

  1. S

    Formula =if(sumif,... Not calculating properly

    Hi everyone, here is my formula, =IF(SUMIF(Table1[State], "TEXAS",Table1[Tax Amount])-SUM(BH4820:BH4900)=0, SUMIF(Table1[State], "TEXAS",Table1[Tax Amount]), "INCORRECT " & SUMIF(Table1[State], "TEXAS",Table1[Tax Amount])-SUM(BH4820:BH4900)) In a nutshell, I have a table, Table1, that...
  2. S

    How to automatically populate table fields with excel hyperlinks

    Hi, I am a new user to this site, but I have looked at it before and it has been very helpful. So thanks for that everyone. Back to my question, is it possible to automatically populate table fields with hyperlinks to all worksheets within one excel file? For example: Say I have Excel File...
  3. S

    How to automatically populate a table field with an excel hyperlink

    Hi, I am a new user to this site, but I have looked at it before and it has been very helpful. So thanks for that everyone. Back to my question, is it possible to automatically populate table fields with hyperlinks to all worksheets within one excel file? For example: Say I have Excel File...
Back
Top Bottom