Logical operator in Calculated Field Formula
 

Hi,
why wouldn't such a formula checking the value of field named "H" to sum
field named "Shop" work?

=(H<0)*Shop

can't we use logical operators in calculated field formulas?

Thanx,
Fatih

Logical operator in Calculated Field Formula
 

Yes, that works. Gives zero if H=0, otherwise gives the value from "Shop".
--
David Biddulph

"Fatih Can1968" wrote in message
...
Hi,
why wouldn't such a formula checking the value of field named "H" to sum
field named "Shop" work?

=(H<0)*Shop

can't we use logical operators in calculated field formulas?

Thanx,
Fatih

Logical operator in Calculated Field Formula
 

The formula works: if H <0, you will get value of SHOP, otherwise 0.

What result do you get / expect to get?

"Fatih Can1968" wrote:

Hi,
why wouldn't such a formula checking the value of field named "H" to sum
field named "Shop" work?

=(H<0)*Shop

can't we use logical operators in calculated field formulas?

Thanx,
Fatih

Logical operator in Calculated Field Formula
 

You need to name column H as H. Otherwise, use:

=(H:H<0)*Shop


- David
xl2003/WinXP

On Jul 11, 11:40 am, Fatih Can1968
wrote:
Hi,
why wouldn't such a formula checking the value of field named "H" to sum
field named "Shop" work?

=(H<0)*Shop

can't we use logical operators in calculated field formulas?

Thanx,
Fatih

Logical operator in Calculated Field Formula
 

Let me be more specific:

My data base is:

Sysyem H Shop
100 2 100
200 2 100
100 2 100
200 0 100

My Pivot Table yields following results

Row Labels Sum of Field1
100 200
200 200
Grand Total 400

formula in calculated field Field1 is : = (H<0)*Shop

Where as for system 200 sum of Field1 must be 100

"Fatih Can1968" wrote:

Hi,
why wouldn't such a formula checking the value of field named "H" to sum
field named "Shop" work?

=(H<0)*Shop

can't we use logical operators in calculated field formulas?

Thanx,
Fatih