•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Receiving #!REF Error Using IF formula
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
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives
#AI formula generation techniques
#formula generator
#Cell Reference Error
#dropdown list
#IF formula
#amount needed in checking
#expenses
#Period 1
#Period 2
#reference text
#total cost
#values 1,2
#cell
#error
#cost