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)

MIKE

Ask Your Question

Weekly Poll

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History