How can I convert this Excel formula work with Numbers?

Question

Level 1

6 points

How can I convert this Excel formula work with Numbers?

Ok, one more question, I have imported an excel sheet to numbers and working the kinks out. One formula is giving me grief. =@IF(B10={"Withdrawal","Deposit"},"", IF(F10="", "", IF(M10="",IF(R10<=0,V10,"SL Not Defined"),IF(I10="","SL Not Defined", IF(N10="", "Pending", ((BJ10*BG10)/W9)))))) If I copy and paste it, it has “@IF” isn’t a valid function name. If I remove the @, the formula stays blank, if I change all the row numbers to match the numbers rows, I get The formula contains a list where a single argument is expected. Any help would be appreciated, thanks.

[Re-Titled by Moderator]

Mac Studio (2022)

Posted on Jan 8, 2024 6:48 PM

Reply

Answer 1

Top-ranking reply

Badunit

Level 7

30,948 points

Jan 15, 2024 4:42 PM in response to frazer227

Your function starts by comparing B10 to a set/list of two strings (Withdrawal and Deposit) and I believe this produces an array of two answers in Excel. If I understand correctly, the @ forces it to return the top (first) answer. So I think you need to replace

=@IF(B10={"Withdrawal","Deposit"}

with

=IF(B10="Withdrawal"

I don't know why the original function started out as it did. It seems overly complex for no reason.

Numbers does not have the @ operator so @IF is not a valid function. The IF function in Numbers does not support comparison to a set, only to a single value. That was the reason for the error message after you deleted the @ operator.

Reply

Answer 2

Jan 15, 2024 2:47 PM in response to frazer227

I can't see how that would have ever worked in Excel either.

JG1

Reply