Syntax - sorry for the simplicity

Question

Level 1

4 points

Syntax - sorry for the simplicity

I'm relatively new to numbers and the syntax is always a bear for me. This formula is throwing a syntax error. Any possible adjustments to fix this? Thanks for your help!

MacBook Air, macOS 13.4

Posted on Jul 20, 2023 5:59 AM

Reply

Answer 1

Top-ranking reply

Barry

Level 9

60,023 points

Jul 20, 2023 1:54 PM in response to KEA_FarNorth

Remove the ) after Current Year (2023) Fee Structure::B$2

Add ,true,"") to the end of the formula.

For a detailed description of IFS and its syntax, type = in any cell of a table in the open document to open the Functions panel, then type IFS in the search bar at the top of the panel to view a description and examples of the IFS function.

Regards,

Barry

Reply

Answer 2

KEA_FarNorth Author

Level 1

4 points

Jul 21, 2023 8:24 PM in response to Barry

Thanks, Barry. That worked for what I wrote above. I hope you'll be willing to expand since I'm missing a very important factor: I need this cell to choose between two conditions:

If K5 is "current" and L5 is "true; get the value indicated at Current Year Fee Structure worksheet in cell B2

OR ...

If K5 is "upcoming" and L5 is "true; get the value indicated at Upcoming Year Fee Structure worksheet in cell B2

I'm attempting to have the spreadsheet auto populate the fee based on which fee structure the client is assigned to. This must be possible somehow!! Right?

Thanks for looking!

Reply

Answer 3

Barry

Level 9

60,023 points

Jul 22, 2023 1:42 AM in response to KEA_FarNorth

Here's one way of doing what you ask:

The formula shown is entered in cell G2 of Table 1, and filled down to cell G5.

The formula follows the instructions for your two sets of conditions.

Values on the two smaller tables were entered manually, and are set to confirm which cells have been copied to column G of Table 1.

Regards,

Barry

Reply

Answer 4

KEA_FarNorth Author

Level 1

4 points

Jul 22, 2023 6:51 AM in response to Barry

THANK YOU! THANK YOU! THANK YOU!!!!! You're amazing! You have a gift for explaining things extraordinarily well - I greatly appreciate that you share that teaching talent here.

Reply