I have 4 columns c, d, e with different values and problem is getting a vaule in f where the logic is: if c=0 and d>0 then the value of f should be -35 or eqal the value of e. How to write the formula
Try this: =IF(Logical_test , value_true , value_false)
Logical test = and(c1=0,d1>0)
value_true= -35
value_false= e1=IF(AND(C1=0,D1>0),-35,E1)