Formula help, please

[mgoldman]

I'm an Excel novice and can't seem to grasp nested formulas. Can
someone please show me how to create a formula that will do what this
logical statement does:

IF F2=0.00 and G2=0.00 and H2=0.00 and I2=0.00 and J2=0.00,
THEN "No Prices"
IF NOT (meaning if any one or more of the results is more than 0.00)
THEN "OK"

Seems simple in English.....

Thanks,
Mike

 

[Mike Middleton]

Mike -

=IF(AND(F2<=0,G2<=0,H2<=0,I2<=0,J2<=0),"No Prices","OK")

- Mike
www.mikemiddleton.com

 

[JE McGimpsey]

I'm an Excel novice and can't seem to grasp nested formulas. Can
someone please show me how to create a formula that will do what this
logical statement does:

IF F2=0.00 and G2=0.00 and H2=0.00 and I2=0.00 and J2=0.00,
THEN "No Prices"
IF NOT (meaning if any one or more of the results is more than 0.00)
THEN "OK"

Seems simple in English.....

One way:

=IF(COUNTIF(F2:J2,">0"),"OK","No Prices")

 

[Bob Greenblatt]

One way:

=IF(COUNTIF(F2:J2,">0"),"OK","No Prices")

Or, isn't it simpler still as:
=if(sum(f2:j2)=0,"No Prices","OK")

 

[JE McGimpsey]

On 9/27/05 1:18 AM, in article
(e-mail address removed), "JE McGimpsey"


Or, isn't it simpler still as:
=if(sum(f2:j2)=0,"No Prices","OK")

Yup. Thanks. Only functional difference is that COUNTIF will ignore
error values and SUM() won't.