Help with If Cell is blank formula

[clherzog]

I have three columns that are "Arbitration", "Mediation", "Trial". I have three other columns, "Arbitration Review Due to Client", "Mediation Review Due to Client", "Trial Review Due to Client".

If there is a date entered in the "Arbitration" column, I want the "Arbitration Review Due to Client" to take that date and subtract 30 days and enter the value in the cell. If there is no data in the "Arbitration Column" I want it to be left blank. Currently it puts a bunch of #### if there is no data for the formula to find.

I'm having a hard time figuring out how to accomplish this task.

Please help. Thanks in advance!

[loginjmor]

Hi -

Assuming Arbitration is in cell A1 and Arbitration Review is in Cell D1 you could use:

=IF(ISNUMBER(A1),A1-30,"")

Hope this helps.

[clherzog]

Are you able to help with one more?

I have a "Status" column. We'd like it to hide the row if it is "Resolved". Is that a thing that can happen?

[loginjmor]

Hi -

To automatically hide it if it is "Resolved" would take some VBA programming, which is beyond my ability. You could repost that as a separate question and there are lots of people on this forum that can help.

Otherwise, as you enter the word "Resolved on that line, just manually hide the row by selecting the left edge of the row on the row number, right click the mouse button and select "Hide" from the pop up menu. Personally I think this is the better approach rather than going to a custom program. If you have your database already put together and have a ton of them to hide, just sort the data by that column which will get all the "Resolved" s together and hide them all at once.

Hope this helps.