if function

[jv]

Kindly correct my formula,

=IF(D8:F8>C8,"Over budget","")

Actually, the above is:

=IF(D8>C8,"Over budget","")

the advised i got from Roger is quite valuable, but as ive
completed everything, my dept. added 2 more columns to be
sum as(D8:F8)>C8,adding 2 columns more give me #value
result. things now are getting harder and complicated to
me.

Can it be done?

jv

 

[Don Guillett]

Maybe?? you are looking for the sum of d8:f8

IF(D8:F8>C8,"Over budget","")

IF(sum(D8:F8)>C8,"Over budget","")

 

[Frank Kabel]

Hi JV
=IF(sum(D8:F8)>C8,"Over budget","")

Frank

 

[jv]

Don,

Thanks for the info.

jv

-----Original Message-----
Maybe?? you are looking for the sum of d8:f8
IF(sum(D8:F8)>C8,"Over budget","")


--
Don Guillett
SalesAid Software
(e-mail address removed)



.

 

[jv]

Frank,

Thanks a lot.

jv

-----Original Message-----
Hi JV
=IF(sum(D8:F8)>C8,"Over budget","")

Frank



.

 

[Frank Kabel]

hi jv
you're welcome
Frank

 

[Don Guillett]

glad to help