Forum Discussion
Leea24
Mar 18, 2024Copper Contributor
IF function fail
I'm doing an IF function in a table. This is an assignment and the book tells you what to type. I have done this particular function several times, deleted the assignment, started over, and have hi...
HansVogelaar
Mar 18, 2024MVP
Please provide some details.
- What is the formula that you tried to enter?
- Does Excel not accept the formula?
- Or does it return an error value such as #VALUE! ?
- Or does it return a different result than you expected?
- Leea24Mar 18, 2024Copper Contributor
HansVogelaar Is there a way to attach a file? #spill! is the result and I've looked through all of the options for that. Honestly don't understand enough and follow directions.
- HansVogelaarMar 18, 2024MVP
#SPILL! means that the formula wants to return a result to multiple cells, but some or all of those cells are already occupied.
If you cannot attach a file here, you can upload it to for example OneDrive, then share it and post a link in a reply. Or attach it to a private message to me - click on my user picture.
- Leea24Mar 18, 2024Copper ContributorOk..I'll try to get that sent. I tried to widen the column but it's set where the book wants it.