10-28-2006, 06:22 PM
|
 |
"Eagle Eyed" Forum Moderator
|
|
Join Date: 14 Feb 2005
Location: Worcester, UK
MS Office Version:Excel 2003 (Work) and 2007 (Home)
Posts: 6,087
|
|
Quote:
|
Originally Posted by herbh
Is there any way that I can write a formula for which the true answer will be inserted in a different cell than the false answer as in an IF function.
herbh
|
Hi herbh,
Do you mean something like this, insert 10 in A1, then in B1 insert
=IF(A1=10,TRUE,FALSE) then in C1
=IF(A1<>10,TRUE,FALSE)
oldchippy 
|