IF function fail

Question

I'm doing an IF function in a table.&nbsp; This is an assignment and the book tells you what to type.&nbsp; I have done this particular function several times, deleted the assignment, started over, and have hit the same problem.&nbsp; I do not have a clue what to do.&nbsp; Excel is not my forte.

hansvogelaar · Answer

Leea24&nbsp;
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?

&nbsp;

leea24 · Answer

HansVogelaar&nbsp;Is there a way to attach a file?&nbsp; #spill! is the result and I've looked through all of the options for that.&nbsp; Honestly don't understand enough and follow directions.

hansvogelaar · Answer

Leea24&nbsp;
#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.

leea24 · Answer

Ok..I'll try to get that sent. I tried to widen the column but it's set where the book wants it.

hansvogelaar · Answer

Leea24&nbsp;
Your current formula is
&nbsp;
=IF([Specialty]="Loans",[Account Values]*0.0025,0)
&nbsp;
[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
&nbsp;
=IF([@Specialty]="Loans",[@[Account Values]]*0.0025,0)
&nbsp;

Forum Discussion

IF function fail

8 Replies