Show answer when cells are not blank

[chrisboo67]

This formula is in cell A4 : (42-A1)*8.8+(42-A2)*8.8+(45-A3)*7.5. The problem is if there is nothing entered in cells A1, A2, an A3 the result is 1077 which is the same answer if zeros are entered in those cells. I would like the answer to show up only if numbers are entered in cells A1, A2, an A3.

[cffndncr]

Try this out:

=IF(AND(ISNUMBER(A1),ISNUMBER(A2),ISNUMBER(A3)),(42-A1)*8.8+(42-A2)*8.8+(45-A3)*7.5,"")

[MarvinP]

Hi chris and welcome to the forum,

How about something like:

= If(A1*A2*A3=0, "", (42-A1)*8.8+(42-A2)*8.8+(45-A3)*7.5)

[cffndncr]

I just reconsidered: Do you want it to show an answer if all 3 have numbers, or only some? Say for example A1 and A2 have numbers, but A3 is blank?

The above example will only work with a number in A1, A2 and A3. If you want it to work if any of the calls has a number, you can use IF(OR(ISNUMBER(A1),ISNUMBER(A2),ISNUMBER(A3)),(42-A1)*8.8+(42-A2)*8.8+(45-A3)*7.5,"")

[hifliers]

If all cells are blank.. you can use IF(AND(A1="",A2="",A3=""),"",(42-A1)*8.8+(42-A2)*8.8+(45-A3)*7.5)