LinkBack URL
About LinkBacks
Needing to create an IF formula which would give the following as the outcome.
e.g. IF c2>E2 the outcome would be given as 1, if C2<E2 then the outcome would be given as 2 and if C2=E2 then the outcome would be given as X.
Any help appreciated.
Needing to create an IF formula which would give the following as the outcome.
e.g. IF c2>E2 the outcome would be given as 1, if C2<E2 then the outcome would be given as 2 and if C2=E2 then the outcome would be given as X.
Any help appreciated.
=if(c2>e2,1,if(c2<e2,2,"x"))
also depends on what to do if c2 or e2 blank do you still want X if not one way
=IF(C2>E2,1,IF(C2<E2,2,IF(AND(C2="",E2=""),"","x")))
Last edited by martindwilson; 06-20-2010 at 08:45 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
or this: =CHOOSE(SIGN(A1-B1)+2, 2, "x", 1)
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks