Another IF

[phuser]

the cells this calculation is directed at can either contain a number or a
"" value, it works great if one of the cells contains a "", but if there is
actually a number in one of them it still wont calculate, it doesn't add the
numbers up I still just get a blank cell.

=IF(ISERROR('060906'!G16+'060906'!K16),"",IF('060906'!G16+'060906'!K16>0,""))

Any help is truly appreciated

 

[Biff]

Hi!

Not real sure what you're trying to do.

The 1st part of your formula is OK:

=IF(ISERROR('060906'!G16+'060906'!K16),"",

But the 2nd part needs some more explanation:

IF('060906'!G16+'060906'!K16>0,""))

If the sum of the 2 cells is greater than 0 it also returns blank. It
doesn't return a sum under any circumstance. The only possible results will
be blank ("") or FALSE.

Maybe you need something like this:

=IF(COUNT('060906'!G16,'060906'!K16),SUM('060906'!G16,'060906'!K16),"")

Biff

 

[Arvi Laanemets]

Hi

Somehow I have the feeling, the formula below will do for you
=IF(SUM('060906'!G16,'060906'!K16)=0,"",SUM('060906'!G16,'060906'!K16))


Arvi Laanemets

 

[phuser]

You were right on the money Arvi, Thanks so Much

Hi

Somehow I have the feeling, the formula below will do for you
=IF(SUM('060906'!G16,'060906'!K16)=0,"",SUM('060906'!G16,'060906'!K16))


Arvi Laanemets

 

[phuser]

Is it possible to do that same formula with an =< 0

 

[phuser]

This is what I tried, But of course it doesnt work

=IF(ISERROR(F7-K7),"",IF(F7-K7)>0,"",SUM(F7-K7))

I am hoping that if K7 or F7 has a #Value in it, will produce a blank cell,
if the number is less than 0 it will produce a blank cell, if a whole number
is calculated that number will appear

 

[Arvi Laanemets]

Hi

=IF(SUMIF('060906'!G16:K16,"<0",'060906'!G16:K16)=0,"",SUMIF('060906'!G16:K1
6,"<0",'060906'!G16:K16))

, but you can't use non-contignous ranges in this formula.


Arvi Laanemets

 

[phuser]

So Im SOL then?
Because the cells Im am trying to do this with are non-contingnous

 

[Arvi Laanemets]

Hi

=IF(ISERROR('060906'!G16+'060906'!K16),"",IF(('060906'!G16<0)*'060906'!G16+(
'060906'!K16<0)*'060906'!K16=0,"",('060906'!G16<0)*'060906'!G16+('060906'!K1
6<0)*'060906'!K16))

Not very nice-looking, but it'll do.


Arvi Laanemets