software

c10 = 40; d10 can be any number above or below 40. The formula I am using is
supposed to either read the number above or below 40 and read either # over
or # under, depending on which it is. For example, if c10=40 and d10=39.25
then e10 should read .75 under. If c10 and d10 are both forty then it would
read quot;at projectionquot;. Here is the formula:
=IF(OR(D11,C11),IF(D11-C11gt;0,STRING(D11-C11,2)amp;quot;overquot;,IF(D11-C11lt;0,STRING(C11-D11,2)amp;quot;underquot;,quot;at projectionquot;)),quot; quot;)

However, if I put any number other than 40 in d10 I just get a #name error
displayed in the corresponding cell (e10)

Anybody have any ideas?


STRING isn't an excel function I know, that's probably causing your
error.

Try this formula

=IF(D10lt;gt;quot;quot;,IF(D10=C10,quot;at
projectionquot;,TEXT(ABS(D10-C10),quot;.00quot;)amp;IF(D10gt;C10,quot; overquot;,quot; underquot;)),quot;quot;)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=512002I don't believe excel has a STRING function, which causes the NAME error.
There is a CONCATENATE function or you can just use the apersand amp;

=IF(OR(D11lt;gt;quot;quot;,C11lt;gt;quot;quot;),IF(D11=C11,quot;at
projectionquot;,ABS(D11-C11)amp;(IF(D11gt;C11,quot; overquot;,quot; underquot;))),quot;quot;)

quot;Excel Experimenterquot; wrote:

gt; c10 = 40; d10 can be any number above or below 40. The formula I am using is
gt; supposed to either read the number above or below 40 and read either # over
gt; or # under, depending on which it is. For example, if c10=40 and d10=39.25
gt; then e10 should read .75 under. If c10 and d10 are both forty then it would
gt; read quot;at projectionquot;. Here is the formula:
gt; =IF(OR(D11,C11),IF(D11-C11gt;0,STRING(D11-C11,2)amp;quot;overquot;,IF(D11-C11lt;0,STRING(C11-D11,2)amp;quot;underquot;,quot;at projectionquot;)),quot; quot;)
gt;
gt; However, if I put any number other than 40 in d10 I just get a #name error
gt; displayed in the corresponding cell (e10)
gt;
gt; Anybody have any ideas?

Hi

Just to add and hopefully clear the haze: VBA has a String function. Its
purpose is to repeat some string a chosen number of times.

Wigi

quot;JMBquot; wrote:

gt; I don't believe excel has a STRING function, which causes the NAME error.