| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculated Field Total formula not working | Excel Worksheet Functions | |||
| Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
| Using a MIN, MAX formula on a calculated field in a pivot table | Excel Discussion (Misc queries) | |||
| How to type correctly formula in calculated field in a pivot? | Excel Worksheet Functions | |||
![Fatih Can1968[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
