You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Hello Guys,
Would you mind helping with the error, here's the formula not sure if this is right, but when I drag the formula to the below row I'm getting an error compares to a string to a number (blue thing)? can you guys help me?
here's the formula that I'm using.
IF(K53>0,IFERROR((K53−L53)×D53×100,"–"),"–")
the other formulas work great, but those columns had already a formula for other columns, will that be an issue?
MacBook Pro 16″, macOS 12.1
Hello SG,
Thank you for replying to this issue, so I switched to "" instead of "-" still the same error? do you think is the formula? or maybe i'm doing something wrong, the reason that I drag it down to next row is to automatically copy that formula, as you can see all other colums have formulas and it populates "-" this as not data found. How do I look for all to be text? how the other columns return just find w/ "-")
forgot to mention that J52 has another formula, so that might the issue because it has a formula, this template is from apple templates that might the issue also, don't know. If I do it manually, it works but I would like to be able to just put the formula and runs from it.
Thank you so much, it worked, one more thing I have the same issue with the table, do you think I can use the same formula above.
the formula work but when is not data to calculate, it gives me the blue thing again, I want to be able to add this automatically when i add a entry
LARGE(Table 1::B2:B16,1)
SMALL(Table 1::B2:B16,1)
Is not the same. For example, column J of the original table is "Short". Column J of the more recent table is "Spread". An answer given for your first post will not work for the table in your more recent post.
Assuming the formula you posted at the beginning is still valid
IF(K53>0,IFERROR((K53−L53)×D53×100,"–"),"–")
I think it will work if you change it to this:
IF(AND(K53<>"–",L53<>"–"),(K53−L53)×D53×100, "–")
But if K53 really needs to be > 0 versus not a "–", that won't work.
The table in your recent post is not the same as the one in your first post. Which is the correct one?
The problem is that the "–" you have in the formula are text. Can you use "" instead?
SG
No is the same I just wanted to show you that I have a formula only, in all columns.
If you are looking only for the largest and smallest values, you can use MAX and MIN instead of LARGE and SMALL. They ignore text (including ignoring text that is all numbers) and blank cells.
Thank you so much for all your help.
Glad I could help.
If error returning compare to string text.
