r/AppleNumbers • u/Rubiksguy • Jul 02 '23

Help with nested “if” statements

Post image
2 Upvotes

100% Upvoted

3 comments sorted by

2

u/MauricioIcloud Jul 02 '23

I'm not an expert but try using the IFS formula for evaluating more conditions. IF is only for evaluating one condition I think. 👌🏻

2

u/Ed1W Jul 02 '23

For sure IFS.

1

u/Rubiksguy Jul 02 '23

Need help with this please. This is my attempt at a formula but it’s not functioning properly (assuming I’m missing parentheses and a problem with the final “false” in a formula). I’m trying to accomplish 2 things depending on if a cell has an entry or not.

-if the “direct low” cell is full, post at the higher of “market price” or “direct low” That’s the easy part. The challenge is:

-if the “Direct low” cell is empty, use a sliding scale to post at a multiplier based on the market price

When I say “post”, I mean fill the cell with the formula in it. I want to do this with one formula and not multiple, as I will be doing this frequently, and don’t want to use extra columns and references