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.
Hi
I'm trying to populate different sheets from one main sheet but keep on getting the Blue triangles - The formula compares a string to a number.
IF(Costing::Invoice Table::A3≤0,"",Costing::Invoice Table::A3)
MacBook Air, macOS 15.0
The answer depends on what it is you are trying to do. Are you trying to say "if A3 is blank then null string else A3" or do you really mean what you've written, "if A3<=0 then null string else A3" which implies that some items in column A are numbers (not formatted as text) and others are text?
For the first one,
=IF(Costing::Invoice Table::A3="", "", Costing::Invoice Table::A3)
The second will be more difficult so I'll not answer that one now unless that is really what you are asking.
Getting rid of the blue triangles - the formula compares a string to a number.
