1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Receiving #!REF Error Using IF formula

https://preview.redd.it/h5urqiyscs3h1.png?width=1974&format=png&auto=webp&s=aa2ba56a997a669013076f90b6a4c54135a2288d

I am curious as to why I am receiving the Cell Reference Error. As the Cell Exists. I have a dropdown list with Period 1, Period 2 in J4. How am I supposed to reference text?. The issue also occurred when I switched the list to just values 1,2. My End Goal is to have the Cell Titled "Amount Needed in Checking to show the total cost of a certain amount of expenses

submitted by /u/Mountain-Opinion-378
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article