View Single Post
  #2   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

Hi

P.e. with formula on row 2
=IF(B2="","",(B2<"")*SUM(A2,-B2))

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Metallo" wrote in message
...
Hi,

I have a WB, with 3 WSs in it.
Let's call them, A,B,C

The numbers in C are given by A - B
=IF(ISERROR('A-'B),0,'A-B)

The problem is that if I have no data in B then I get A numbers into C

How can I add a third condition to the formula so that when no data are
present in B then it should show Nothing in C?

Thank you!
Alex