Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiplication of a blank cell
Thank you all!!! I cant believe it was so simple....
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiplication | Excel Worksheet Functions | |||
how to get excel to display blank if reference cell blank | Excel Worksheet Functions | |||
Multiplication in one cell | Excel Discussion (Misc queries) | |||
How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) |