View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fatih Can1968[_2_] Fatih Can1968[_2_] is offline
external usenet poster
 
Posts: 2
Default 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