| I have a nested IF formula acting on a cell far above it...when I copy the formula down or across, I get an #VALUE! error message, when the cell above is stark empty.|
The formula works when I put either a zero or a one into the cell upon which the IF formula is acting...
I can even remove the 1 or 0 from that reference cell once I have put the digit into the cell one time, and the IF formula below continues to work
I have tried formatting the reference cell as a number, but it continues to be a problem unless I fill the cell with a one or a zero, and then remove it.
I would use that as a solution, but the spreadsheet of reference cells is 100000 cells...too much work to do manually....help.
Edited by Moderator: All cap removed, Text from second thread added.
One added issue:
In simplest terms: How do I mark empty reference cells in such a way that a formula which acts upon them will see them as a number and not text, there in giving me that crummy #VALUE! error message...
So far, the only thing that works (formatting the cells in that range has failed) is to put a number in that reference cell, then take it out? NOt useful in a spreadsheet of 100000 reference cells, all being acted on by forumulas?
i HAVE A NESTED IF FORMULA ACTING ON A CELL FAR ABOVE IT...WHEN I COPY THE FORMULA DOWN OR ACROSS, I GET AN #VALUE! ERROR MESSAGE, WHEN THE CELL ABOVE IS STARK EMPTY
THE FORMULA WORKS WHEN I PUT EITHER A ZERO OR A ONE INTO THE CELL UPON WHICH THE IF FORMULA IS ACTING...
I CAN EVEN REMOVE THE 1 OR 0 FROM THAT REFERENCE CELL ONCE I HAVE PUT THE DIGIT INTO THE CELL ONE TIME, AND THE IF FORMULA BELOW CONTINUES TO WORK
I HAVE TRIED FORMATTING THE REFERENCE CELL AS A NUMBER, BUT IT CONTINUES TO BE A PROBLEM UNLESS I FILL THE CELL WITH A ONE OR A ZERO, AND THEN REMOVE IT
I WOULD USE THAT AS A SOLUTION, BUT THE SPREADSHEET OF REFERENCE CELLS IS 100000 CELLS...TOO MUCH WORK TO DO MANUALLY....HELP
edited by moderator: All Caps removed, text copied