Apple Numbers - Formula needed that will only calculate if a specific cell value is greater than 0

Hi Nick,

Here are two:

IF(B1>0,A1+B1,"")

IF(B1>0,SUM(A1,B1),"")

In both, you'll need to replace "" with what result you want when B1 is not greater than zero. As written, the result will be the empty string, a text value with 0 length, and the cell containing the formula will appear empty.

Regards,

Barry

I see it is already answered but here is another formula assuming you want A1+B1 if B>0 and want A1 if B<=0

=MAX(A1,A1+B1)

or

=MAX(A1,SUM(A1,B1))

The first will choke if it encounters letters/words instead of numbers and will throw an error. The second will ignore all text (including numbers that are in cells formatted as text) or will consider it to be 0.

I propose this formula that determines if cell B1 contains a numeric value and it is greater than zero. When true, it does the sum of A1, B1, and when false, enters the string "B1 is alpha".

Testing B1 > 0 will return true even when B1 contains "A", and that leads to issues. So we must ensure it is numeric.

IFERROR(IF(REGEX.EXTRACT(B1,"(\d+)",1) > 0,SUM(A1,B1),""),"B1 is alpha")

This basically captures and returns any numeric (\d+) value in cell B1 and compares that to zero. If B1 contains non-numeric data, then it is an extract error, and the error condition text string is inserted into the cell with this formula.

This also handles negative and decimal numbers in cell B1.

Tested: Numbers v12.2, macOS Ventura 13.0.1.