Help with Caluation

[Guest]

I am working on a spread sheet to do caluation. I would like a field to return a product only if there is one to return. Otherwise, I would like it to be blank. Example....if quantity * price = (nothing if no quantity, or product if quantity >0

 

[Bob Phillips]

=IF(OR(price=0,quantity=0),"",price*quantity)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I am working on a spread sheet to do caluation. I would like a field to

return a product only if there is one to return. Otherwise, I would like it
to be blank. Example....if quantity * price = (nothing if no quantity, or
product if quantity >0)

 

[Frank Kabel]

Hi
try something like
=IF(OR(A1="",B1="","",A1*B1)

-----Original Message-----
I am working on a spread sheet to do caluation. I would

like a field to return a product only if there is one to
return. Otherwise, I would like it to be blank.
Example....if quantity * price = (nothing if no quantity,
or product if quantity >0)

 

[Guest]

Thanks! This is great

----- Bob Phillips wrote: ----

=IF(OR(price=0,quantity=0),"",price*quantity

--

HT

Bob Phillip
... looking out across Poole Harbour to the Purbeck
(remove nothere from the email address if mailing direct

I am working on a spread sheet to do caluation. I would like a field t

return a product only if there is one to return. Otherwise, I would like i
to be blank. Example....if quantity * price = (nothing if no quantity, o
product if quantity >0

 

[Guest]

Thanks! You are a life saver!


----- Frank Kabel wrote: -----

Hi
try something like
=IF(OR(A1="",B1="","",A1*B1)

-----Original Message-----
I am working on a spread sheet to do caluation. I would

like a field to return a product only if there is one to
return. Otherwise, I would like it to be blank.
Example....if quantity * price = (nothing if no quantity,
or product if quantity >0)