nested formula & reference a cell from another table

  • Resolved emlickwid

    (@emlickwid)


    6 years, 2 months ago

    We use wordpress on our intranet and I am trying to create a table that references a cell from another table. I see that i can use: [table-cell id=123 cell=C3 /] but the cell ‘C3’ is a formula so it pull in the formula rather than the result of the formula.

    Can Tablepress handle nested IF statements like this: =IF(D1<B20,C20,IF(D1<B21,C21,IF(D1<B22,C22,IF(D1<B23,C23,IF(D1<B24,C24,IF(D1>A25,C25))))))
    ?
    thanks
    Em

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    The nested IF statement should work fine – if all of the referenced cells are numbers or valid formulas.

    Unfortunately, referencing a cell from another table (using [table-cell ... /]) will always only return the raw cell value, so that it’s not possible to get calculated values from this, sorry.

    Regards,
    Tobias

    Thread Starter emlickwid

    (@emlickwid)

    Hello Tobias
    thanks for the rapid response.
    My workaround was to put all the data in one table and hide rows so that i can reference and calculate cells within the same table as opposed to referencing other tables.

    Now I just need to figure out how to allow people accessing the site to enter certain information via contact-form-7 and that information referenced to the table!

    is there a forum for integrating tablepress with a form plug-in?

    thanks
    Em

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    good to hear that you were able to merge the tables!

    Unfortunately, I’m not aware of a solution that would allow user entered information to be used in tables or formulas in tables ?? Sorry.

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘nested formula & reference a cell from another table’ is closed to new replies.