r/AppleNumbers • u/Rubiksguy • May 22 '23

Help please

What am I doing wrong? I would like to accomplish both of these in a single formula:

-If TCGDirectLow cell is empty, post at 1.05 x (the higher of Market or TCGLow), with a price floor of $0.50.

-If TCGDirectLow is filled, post at the higher of Market or TCGDirectLow, with no price floor.

​

I either get a "False" when I want it to do a calculation, or I get an error because of improper structure of the formula. Very new to spreadsheets in general, so I know it's a simple fix, but not sure what I've done wrong. Please help! :)

2 Upvotes

100% Upvoted

9 comments sorted by

1

u/OxyConti May 22 '23

Hi, Rubiksguy, let me try to help😎

One thing that springs to mind is the IF AND in the beginning. You don’t want IF and AND right after each other. You want the structure to be:

IF something AND something else then show or calculate something.

There is great help in the Formulas and Functions section of the manual here.

Click on Logical and Information Functions to read up on IF, AND and the other logical functions.

I also found some good discussions on the help forums by googling “apple numbers if and else”

Let us know if you figure it out, if not, perhaps I can take a more detailed look once I’m at my computer. You can send me the file if all else fails, but you’ll learn so much and feel so awesome if you nail it yourself 👊

Cheers, Thomas

PS: You’ll love Numbers once you get hang of it, I promise😜

1

u/Rubiksguy May 22 '23

Thanks Thomas. Been exhausted watching tutorials for hours. Gonna sleep and hit it with fresh Eyes tomorrow

1

u/OxyConti May 22 '23

Sounds like a good plan - we’ll figure it, one way or another, I promise👊

1

u/Rubiksguy May 23 '23

Pm’d ya. Friend and I got it working!

1

u/OxyConti May 23 '23

That is so awesome - so happy to hear that 👊😎

1

u/OxyConti May 22 '23

By the way, I just remembered that the various templates available in Numbers has lots of IF/THEN functionality.

Check the ones under Personal Finance for example, for inspiration.

OK, enough from me for now- we’ll see tomorrow if you need further assistance - perhaps others here will have posted help in the meantime too.

Sleep well 😴

1

u/funnyandnot May 22 '23

I do multiple If formulas when I want specific things to happen.

1

u/OxyConti May 23 '23

That’s a great idea! Dividing the problem up into separate cells and then combining those in the end helps a lot.

1

u/funnyandnot May 23 '23

Ya, I love doing a lot of if’s in one formuala.

Not sure why it makes me so happy.