User Profile
JohnTheDog
Copper Contributor
Joined Feb 27, 2023
User Widgets
Recent Discussions
Can you have IF functions produce blank cells which can be written in without removing the IF?
I'm trying to create a table which copies rows if the ID number is equal and to do that I've used a series of if functions in each column to copy the data from the original row of the same ID. One issue i have is if a new set of variables need to be put in the IF formula would have to be deleted which I don't want as the information tends to move up and down the table or be edited. Is there anyway for me to have it so that when it is returned with a blank cell that it can be written in without it removing the IF function?509Views0likes1Comment
Recent Blog Articles
No content to show