having problem in defining a condition excel

November 28, 2010 at 01:32:06
Specs: Windows XP
how to apply condition in excel2003/2007 if i want that if the value in a1 is 95 then the value in a3 should automatically be picked to -1

See More: having problem in defining a condition excel

Report •

#1
November 28, 2010 at 07:57:16
You didn't say what you want if A1 <> 95. This formula will result in a blank cell is A1<>95, -1 if it is.

=IF(A1=95,-1,"")

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •
Related Solutions


Ask Question