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.
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.
Another option for text to avoid the result being a 0 when the cell is blank is
=Costing::Invoice Table::A3&""
The result will be text so it may not be something you want to do with data formats other than text unless the results are just for show and are not used in any downstream formulas.
Thx that solved my problem, yes it is the first option.
Getting rid of the blue triangles - the formula compares a string to a number.
