multiplication of a blank cell
 

I know my title is an OXYMORON, what I described cannot be done, however here
is what I have to work with.... I have my pricing guide setup to calculate
cost based upon the master table item pricing. It populates the price based
upon the SKU number entered, if no SKU is entered it leaves the cell blank.
This is fine.

When I go to my estimate worksheet and enter the following ....
=IF('.'!G44="","",'.'!G44)*Info!AA44 ...
('.'!G44 is the cost from my pricing page times a markup *Info!AA44)
this gives me #VALUE.

Can I take this and make it blank if there is #VALUE? It changes all of my
tax and total fields to #VALUE and basically wipes out my entire 8 page
workbook
Thanks in advance

multiplication of a blank cell
 

Try this:

=IF('.'!G44="","",'.'!G44*Info!AA44)

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"jerminski73" wrote in message
...
I know my title is an OXYMORON, what I described cannot be done, however
here
is what I have to work with.... I have my pricing guide setup to
calculate
cost based upon the master table item pricing. It populates the price
based
upon the SKU number entered, if no SKU is entered it leaves the cell
blank.
This is fine.

When I go to my estimate worksheet and enter the following ....
=IF('.'!G44="","",'.'!G44)*Info!AA44 ...
('.'!G44 is the cost from my pricing page times a markup *Info!AA44)
this gives me #VALUE.

Can I take this and make it blank if there is #VALUE? It changes all of
my
tax and total fields to #VALUE and basically wipes out my entire 8 page
workbook
Thanks in advance

multiplication of a blank cell
 

What if you change your formula to =IF('.'!G44="","",'.'!G44*Info!AA44) ?
--
David Biddulph

"jerminski73" wrote in message
...
I know my title is an OXYMORON, what I described cannot be done, however
here
is what I have to work with.... I have my pricing guide setup to
calculate
cost based upon the master table item pricing. It populates the price
based
upon the SKU number entered, if no SKU is entered it leaves the cell
blank.
This is fine.

When I go to my estimate worksheet and enter the following ....
=IF('.'!G44="","",'.'!G44)*Info!AA44 ...
('.'!G44 is the cost from my pricing page times a markup *Info!AA44)
this gives me #VALUE.

Can I take this and make it blank if there is #VALUE? It changes all of
my
tax and total fields to #VALUE and basically wipes out my entire 8 page
workbook
Thanks in advance

multiplication of a blank cell
 

You are trying to multiply "" by the value in AA44,
Try moving the bracket after G44 to after AA44
Regards

"jerminski73" wrote:

I know my title is an OXYMORON, what I described cannot be done, however here
is what I have to work with.... I have my pricing guide setup to calculate
cost based upon the master table item pricing. It populates the price based
upon the SKU number entered, if no SKU is entered it leaves the cell blank.
This is fine.

When I go to my estimate worksheet and enter the following ....
=IF('.'!G44="","",'.'!G44)*Info!AA44 ...
('.'!G44 is the cost from my pricing page times a markup *Info!AA44)
this gives me #VALUE.

Can I take this and make it blank if there is #VALUE? It changes all of my
tax and total fields to #VALUE and basically wipes out my entire 8 page
workbook
Thanks in advance

multiplication of a blank cell
 

One way
Try it like this:
=IF('.'!G44="","",'.'!G44*Info!AA44)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"jerminski73" wrote:
I know my title is an OXYMORON, what I described cannot be done, however here
is what I have to work with.... I have my pricing guide setup to calculate
cost based upon the master table item pricing. It populates the price based
upon the SKU number entered, if no SKU is entered it leaves the cell blank.
This is fine.

When I go to my estimate worksheet and enter the following ....
=IF('.'!G44="","",'.'!G44)*Info!AA44 ...
('.'!G44 is the cost from my pricing page times a markup *Info!AA44)
this gives me #VALUE.

Can I take this and make it blank if there is #VALUE? It changes all of my
tax and total fields to #VALUE and basically wipes out my entire 8 page
workbook
Thanks in advance

multiplication of a blank cell
 

Thank you all!!! I cant believe it was so simple....