Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying To Roundup only if more than zero
Okay so im trying to set up a quote sheet for when a customer comes in and wants me to build a new computer for them the problem that I have is, I have an upgrade area at the bottom of the last workbook titled "final" it's suppose to take the price from the upgrades area on "pirces" and round it up to the nearest ten dollar amoust eg. monitor price $261.60 rounded up to $270.00 and then add on $9.99 so it equals $279.99 that part works fine but when the cell is empty (instead of $261.60 it's $0.00 the final cell turns out to be the $9.99) I want to be able to have it show up $0.00 on the final cell I've uploaded the book to my website (Link Below) if someone could take a look at it and give some help it would be greatly appreciated. if you would like to talk to me my e-mail is thanks. http://www.rentageekusa.com/Quote.xls -- G33kman ------------------------------------------------------------------------ G33kman's Profile: http://www.excelforum.com/member.php...o&userid=29189 View this thread: http://www.excelforum.com/showthread...hreadid=489189 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying To Roundup only if more than zero
All you should need is to add an If Condition to check if the cell is blank. =If(A1="",0,Round.......), Where A1 is the cell containing the initial value, and Round...is your formula for rounding etc... -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=489189 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying To Roundup only if more than zero
An IFless alternatve
=ROUNDUP(A21,-1)+(A210)*9.99 -- HTH RP (remove nothere from the email address if mailing direct) "Vito" wrote in message ... All you should need is to add an If Condition to check if the cell is blank. =If(A1="",0,Round.......), Where A1 is the cell containing the initial value, and Round...is your formula for rounding etc... -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=489189 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
roundup within a formula | Excel Worksheet Functions | |||
ROUNDUP copy/paste and fill handle not working | Excel Worksheet Functions | |||
Roundup for multiple cells | Excel Discussion (Misc queries) | |||
roundup within a formula | Excel Worksheet Functions | |||
How do I use Roundup in a logical test in excel | Excel Worksheet Functions |