Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding Results when result should read blank
I am using the formula below to create a sell sheet for my sales people. This
formula takes my fob costs from my fob worksheet and this formula takes the fob prices and adds on the $4.50 for delivery. This works great in most instances. I have several items that say have a fob cost of $10.64. So in this instance, the sell price would be $15.14. What I want to be able to do, is to have the result from this formula round up the sell price to the next highest $.10. For example, I would like to have this result come out at $15.20. I have taken this formula and used in hidden cells and then had that result carried over to the cell for my sell sheet and used a roundup formula that works ok, but in the case when say this particular item isnt available and there is no fob cost loaded on my fob sheet, the result in the cell for the salesman copy reads as #VALUE. I just as soon not go this way and looking for answers to show nothing if there is no fob cost listed. =IF(FOBSHEET!B116="","",FOBSHEET!B116+4.5) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding Results when result should read blank
Try
=IF(Fobsheet!B116="","",ROUNDUP(Fobsheet!B116+4.5, 1)) Mike "Looking for help today" wrote: I am using the formula below to create a sell sheet for my sales people. This formula takes my fob costs from my fob worksheet and this formula takes the fob prices and adds on the $4.50 for delivery. This works great in most instances. I have several items that say have a fob cost of $10.64. So in this instance, the sell price would be $15.14. What I want to be able to do, is to have the result from this formula round up the sell price to the next highest $.10. For example, I would like to have this result come out at $15.20. I have taken this formula and used in hidden cells and then had that result carried over to the cell for my sell sheet and used a roundup formula that works ok, but in the case when say this particular item isnt available and there is no fob cost loaded on my fob sheet, the result in the cell for the salesman copy reads as #VALUE. I just as soon not go this way and looking for answers to show nothing if there is no fob cost listed. =IF(FOBSHEET!B116="","",FOBSHEET!B116+4.5) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding Results of Answers for a Quiz | Excel Discussion (Misc queries) | |||
Hiding the results of a formula generated from a blank cell | Excel Discussion (Misc queries) | |||
Hiding results | Excel Discussion (Misc queries) | |||
hiding blank cells when no results | Excel Worksheet Functions | |||
Excel 2003 Hiding #DIV/0 in Data/Subtotal/Avg result | Excel Discussion (Misc queries) |