How would you write this formula in numbers?

IF(F3=””,””,F3-F4)

this is a excel formula I use quite a lot.

Thank you for any and all help provided.

iPad Pro, iPadOS 18

Posted on Mar 3, 2025 1:07 PM

Reply
Question marked as Top-ranking reply

Posted on Mar 3, 2025 3:10 PM

For the most part (for better or worse) Excel formulas and Numbers formulas are cross-compatible. It makes it far easier for users to migrate to Numbers from Excel, and there's a huge saving for Apple not having to reinvent the wheel (discussion whether or not that wheel needs re-inventing I'll leave for a different day :)


It probably looks different because of how Numbers highlights referenced cells in the spreadsheet:



For any referenced cell, Numbers shows the reference (e.g 'F3' or 'F4' in this example) in a colored oval to help distinguish it from plain text, or a function name. It also highlights the cell itself in the same color to give a visual clue as to where the formula is referencing.


If you copy the formula and paste it into a text-based application, you get the 'plain' version: =IF(F3="","",F3-F4), so it's mostly just a visual thing.

4 replies
Question marked as Top-ranking reply

Mar 3, 2025 3:10 PM in response to eact

For the most part (for better or worse) Excel formulas and Numbers formulas are cross-compatible. It makes it far easier for users to migrate to Numbers from Excel, and there's a huge saving for Apple not having to reinvent the wheel (discussion whether or not that wheel needs re-inventing I'll leave for a different day :)


It probably looks different because of how Numbers highlights referenced cells in the spreadsheet:



For any referenced cell, Numbers shows the reference (e.g 'F3' or 'F4' in this example) in a colored oval to help distinguish it from plain text, or a function name. It also highlights the cell itself in the same color to give a visual clue as to where the formula is referencing.


If you copy the formula and paste it into a text-based application, you get the 'plain' version: =IF(F3="","",F3-F4), so it's mostly just a visual thing.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How would you write this formula in numbers?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.