software

Is it possible to not change the contents of a cell if the @IF condition
returns FALSE?


Hi,

Try surround your formula with :
=IF(ISERROR(yourformula),quot;quot;,yourformula)

HTH
Carim--
Carim
------------------------------------------------------------------------
Carim's Profile: www.excelforum.com/member.php...oamp;userid=33259
View this thread: www.excelforum.com/showthread...hreadid=531769another way would be to tell us what your formula actually looks like\
generally if(a1=1,a2*2,a2),ie if condtion is true multiply a2x2 if false a2
is ummm a2
--
paul

remove nospam for email addy!
quot;Carimquot; wrote:

gt;
gt; Hi,
gt;
gt; Try surround your formula with :
gt; =IF(ISERROR(yourformula),quot;quot;,yourformula)
gt;
gt; HTH
gt; Carim
gt;
gt;
gt; --
gt; Carim
gt; ------------------------------------------------------------------------
gt; Carim's Profile: www.excelforum.com/member.php...oamp;userid=33259
gt; View this thread: www.excelforum.com/showthread...hreadid=531769
gt;
gt;

Thanks for the replies. Basically I want to do the following.
I have a global name GlobalName defined. It can have the values quot;Aquot; or quot;Bquot;.

In cell a2: @if(GlobalName = quot;Aquot;, a1)
In cell b2: @if(GlobalName = quot;Bquot;, b1)

If cell a2 has the value from a1 then if GlobalName = quot;Bquot;, I want cell a2 to
stay the same and not get changes. This may be an invalid attempt on my part
but basically, if the IF condition is FALSE, then do a NOOP.

Petequot;paulquot; wrote:

gt; another way would be to tell us what your formula actually looks like\
gt; generally if(a1=1,a2*2,a2),ie if condtion is true multiply a2x2 if false a2
gt; is ummm a2
gt; --
gt; paul
gt;
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;Carimquot; wrote:
gt;
gt; gt;
gt; gt; Hi,
gt; gt;
gt; gt; Try surround your formula with :
gt; gt; =IF(ISERROR(yourformula),quot;quot;,yourformula)
gt; gt;
gt; gt; HTH
gt; gt; Carim
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Carim
gt; gt; ------------------------------------------------------------------------
gt; gt; Carim's Profile: www.excelforum.com/member.php...oamp;userid=33259
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=531769
gt; gt;
gt; gt;