Simple Formula

[ExcelRoy]

Hi Guys,

I have a simple formula that returns a #VALUE error

How do i change to avoid the error

=IF(SUM(Q146-Q142)="","",SUM(Q146-Q142))

Thanks

 

[ExcelRoy]

As an example of what is in Q16

=IF(N16="","",SUM(B16*N16))

B16 being "Quantity"
N16 being "Unit Price"

Thanks

 

[Aladin Akyurek]

As an example of what is in Q16

=IF(N16="","",SUM(B16*N16))

B16 being "Quantity"
N16 being "Unit Price"

Thanks

Modify it to...

=IF(N6="","",B16*N16)

I think the following would cope with all these blanks you create...

=IF(AND(Q142="",Q146=""),"",Q146-Q142)

which requires that we have numbers in both Q142 and Q146.

 

[ExcelRoy]

Hi Aladin,

I will use helper rows to achieve my goals on this one. Not ideal> But a solution

How would i return a "" result with the following formula if i have a "#DIV/0!" error

=IF(W153=0,"",W153)

Thanks

 

[Aladin Akyurek]

Hi Aladin,

I will use helper rows to achieve my goals on this one. Not ideal> But a solution

Ok, but not sure I understand the solution.

How would i return a "" result with the following formula if i have a "#DIV/0!" error

=IF(W153=0,"",W153)

...

Does this...

=IF(ISNUMBER(W153),IF(W153=0,"",W153),"")

help?

 

[T. Valko]

Try this...

=IF(COUNT(Q142,Q146)<2,"",Q146-Q142)

HHhmmm

I must be doing something wrong, none of these formula's work?
They all show "" and no sums?

Q142 is an overall total of merged cells (Q15:S138) with specific wording

If that formula returns a blank then that means the target cells do not contain numeric numbers.

What does "with specific wording" mean?