#name error
 

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 "at projection". Here is the formula:
=IF(OR(D11,C11),IF(D11-C110,STRING(D11-C11,2)&"over",IF(D11-C11<0,STRING(C11-D11,2)&"under","at projection"))," ")

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?

#name error
 

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

Try this formula

=IF(D10<"",IF(D10=C10,"at
projection",TEXT(ABS(D10-C10),".00")&IF(D10C10," over"," under")),"")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=512002

#name error
 

I 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 &

=IF(OR(D11<"",C11<""),IF(D11=C11,"at
projection",ABS(D11-C11)&(IF(D11C11," over"," under"))),"")

"Excel Experimenter" wrote:

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 "at projection". Here is the formula:
=IF(OR(D11,C11),IF(D11-C110,STRING(D11-C11,2)&"over",IF(D11-C11<0,STRING(C11-D11,2)&"under","at projection"))," ")

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?

#name error
 

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

"JMB" wrote:

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