I’m doing some formatting of a spreadsheet. The spreadsheet has columns A-N. I’m adding Columns O-U. Column U needs to have a formula =T2-A2. The issue I’m having is right now there is no data in column T as I am just formatting the spreadsheet for someone else’s use and they will be filling in any data for that column. I would just like to have that formula prepared for them when they add data to column T. Is this possible? if so, can you provide the formula or logic needed to accomplish this? I’ve tried several times on my own and I am coming up unsuccessful. When I debug, i don’t get an error, the automation never stops. I’m wondering if it’s looking for data in Column T that’s not there. Should i be using =IF(ISBLANK(T2), “”, T2-A2)?
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale
Anil_G
Soudios
ppr
Yoichi
lrtetala
Anjani_Kapoor
sarikayaebru
rodrigo.simao
Jon_Smith