Forum Discussion
IF function fail
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.
#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.
- Ok..I'll try to get that sent. I tried to widen the column but it's set where the book wants it.
Your current formula is
=IF([Specialty]="Loans",[Account Values]*0.0025,0)
[Specialty] and [Account Values] refer to the entire table column of that name; that won't work. You have to refer to the item in the current row instead. To do that, use [@Specialty] and[@[Account Values]]. The extra brackets in the latter one are necessary because of the space in the column name.
So the formula becomes
=IF([@Specialty]="Loans",[@[Account Values]]*0.0025,0)
- Worked!! I NEVER would've figured that out and the instructor would not have responded until Monday.