if and or together in excel

March 11, 2011 at 22:54:18
Specs: Windows XP
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

See More: if and or together in excel

Report •

March 12, 2011 at 06:20:49
Try this:

=IF(Logical_test , value_true , value_false)

Logical test = and(c1=0,d1>0)
value_true= -35
value_false= e1




Report •
Related Solutions

Ask Question