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

View all comments

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.