| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement to replace #VALUE! code
Hi Experts:
I know this is fundamental to formulas, but I'm doing something wrong..N20 returns #VALUE! if N21 is Blank......I want to it to state: If Cell N21 is Blank, Insert 0:00:00 The existing formula that I want to add this statement to is: =ROUND(TRIM(N21)*1440,0)/60 Can anyone help? -- jeannie v |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement to replace #VALUE! code
Try
=ROUND(TRIM(N(N21))*1440,0)/60 -- Regards, Peo Sjoblom "jeannie v" wrote in message ... Hi Experts: I know this is fundamental to formulas, but I'm doing something wrong..N20 returns #VALUE! if N21 is Blank......I want to it to state: If Cell N21 is Blank, Insert 0:00:00 The existing formula that I want to add this statement to is: =ROUND(TRIM(N21)*1440,0)/60 Can anyone help? -- jeannie v |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement to replace #VALUE! code
Peo:
That you so much.....it works just fine! -- jeannie v "Peo Sjoblom" wrote: Try =ROUND(TRIM(N(N21))*1440,0)/60 -- Regards, Peo Sjoblom "jeannie v" wrote in message ... Hi Experts: I know this is fundamental to formulas, but I'm doing something wrong..N20 returns #VALUE! if N21 is Blank......I want to it to state: If Cell N21 is Blank, Insert 0:00:00 The existing formula that I want to add this statement to is: =ROUND(TRIM(N21)*1440,0)/60 Can anyone help? -- jeannie v |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement to replace #VALUE! code
Peo:
I spoke too soon....It's true that it did give me the 0:00, but I didn't make my question clear enough....I also want it to return the formulated value other than 0:00:00 if it exists....Example: If N21 is blank, return 0.00, but if N21 is 6:53:32, return that result value of the formula: =ROUND(TRIM(N21)*1440,0)/60 Does that make sense? Thank you for your help, -- jeannie v "Peo Sjoblom" wrote: Try =ROUND(TRIM(N(N21))*1440,0)/60 -- Regards, Peo Sjoblom "jeannie v" wrote in message ... Hi Experts: I know this is fundamental to formulas, but I'm doing something wrong..N20 returns #VALUE! if N21 is Blank......I want to it to state: If Cell N21 is Blank, Insert 0:00:00 The existing formula that I want to add this statement to is: =ROUND(TRIM(N21)*1440,0)/60 Can anyone help? -- jeannie v |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement to replace #VALUE! code
try this one
=IF(N21="","0:00:00",ROUND(TRIM(N21)*1440,0)/60) regards, driller -- ***** birds of the same feather flock together.. "jeannie v" wrote: Peo: I spoke too soon....It's true that it did give me the 0:00, but I didn't make my question clear enough....I also want it to return the formulated value other than 0:00:00 if it exists....Example: If N21 is blank, return 0.00, but if N21 is 6:53:32, return that result value of the formula: =ROUND(TRIM(N21)*1440,0)/60 Does that make sense? Thank you for your help, -- jeannie v "Peo Sjoblom" wrote: Try =ROUND(TRIM(N(N21))*1440,0)/60 -- Regards, Peo Sjoblom "jeannie v" wrote in message ... Hi Experts: I know this is fundamental to formulas, but I'm doing something wrong..N20 returns #VALUE! if N21 is Blank......I want to it to state: If Cell N21 is Blank, Insert 0:00:00 The existing formula that I want to add this statement to is: =ROUND(TRIM(N21)*1440,0)/60 Can anyone help? -- jeannie v |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement to replace #VALUE! code
Dear, Dear driller:
It works just great! Thank You! -- jeannie v "driller" wrote: try this one =IF(N21="","0:00:00",ROUND(TRIM(N21)*1440,0)/60) regards, driller -- ***** birds of the same feather flock together.. "jeannie v" wrote: Peo: I spoke too soon....It's true that it did give me the 0:00, but I didn't make my question clear enough....I also want it to return the formulated value other than 0:00:00 if it exists....Example: If N21 is blank, return 0.00, but if N21 is 6:53:32, return that result value of the formula: =ROUND(TRIM(N21)*1440,0)/60 Does that make sense? Thank you for your help, -- jeannie v "Peo Sjoblom" wrote: Try =ROUND(TRIM(N(N21))*1440,0)/60 -- Regards, Peo Sjoblom "jeannie v" wrote in message ... Hi Experts: I know this is fundamental to formulas, but I'm doing something wrong..N20 returns #VALUE! if N21 is Blank......I want to it to state: If Cell N21 is Blank, Insert 0:00:00 The existing formula that I want to add this statement to is: =ROUND(TRIM(N21)*1440,0)/60 Can anyone help? -- jeannie v |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement to replace #VALUE! code
"De Nada"
-- ***** birds of the same feather flock together.. "jeannie v" wrote: Dear, Dear driller: It works just great! Thank You! -- jeannie v "driller" wrote: try this one =IF(N21="","0:00:00",ROUND(TRIM(N21)*1440,0)/60) regards, driller -- ***** birds of the same feather flock together.. "jeannie v" wrote: Peo: I spoke too soon....It's true that it did give me the 0:00, but I didn't make my question clear enough....I also want it to return the formulated value other than 0:00:00 if it exists....Example: If N21 is blank, return 0.00, but if N21 is 6:53:32, return that result value of the formula: =ROUND(TRIM(N21)*1440,0)/60 Does that make sense? Thank you for your help, -- jeannie v "Peo Sjoblom" wrote: Try =ROUND(TRIM(N(N21))*1440,0)/60 -- Regards, Peo Sjoblom "jeannie v" wrote in message ... Hi Experts: I know this is fundamental to formulas, but I'm doing something wrong..N20 returns #VALUE! if N21 is Blank......I want to it to state: If Cell N21 is Blank, Insert 0:00:00 The existing formula that I want to add this statement to is: =ROUND(TRIM(N21)*1440,0)/60 Can anyone help? -- jeannie v |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement to replace #VALUE! code
It does, you just have to make sure the cell with the formula is formatted
as time -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "jeannie v" wrote in message ... Peo: I spoke too soon....It's true that it did give me the 0:00, but I didn't make my question clear enough....I also want it to return the formulated value other than 0:00:00 if it exists....Example: If N21 is blank, return 0.00, but if N21 is 6:53:32, return that result value of the formula: =ROUND(TRIM(N21)*1440,0)/60 Does that make sense? Thank you for your help, -- jeannie v "Peo Sjoblom" wrote: Try =ROUND(TRIM(N(N21))*1440,0)/60 -- Regards, Peo Sjoblom "jeannie v" wrote in message ... Hi Experts: I know this is fundamental to formulas, but I'm doing something wrong..N20 returns #VALUE! if N21 is Blank......I want to it to state: If Cell N21 is Blank, Insert 0:00:00 The existing formula that I want to add this statement to is: =ROUND(TRIM(N21)*1440,0)/60 Can anyone help? -- jeannie v |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement to replace #VALUE! code
What's the point of returning a text string if N21 is blank, why not just 0?
-- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "driller" wrote in message ... try this one =IF(N21="","0:00:00",ROUND(TRIM(N21)*1440,0)/60) regards, driller -- ***** birds of the same feather flock together.. "jeannie v" wrote: Peo: I spoke too soon....It's true that it did give me the 0:00, but I didn't make my question clear enough....I also want it to return the formulated value other than 0:00:00 if it exists....Example: If N21 is blank, return 0.00, but if N21 is 6:53:32, return that result value of the formula: =ROUND(TRIM(N21)*1440,0)/60 Does that make sense? Thank you for your help, -- jeannie v "Peo Sjoblom" wrote: Try =ROUND(TRIM(N(N21))*1440,0)/60 -- Regards, Peo Sjoblom "jeannie v" wrote in message ... Hi Experts: I know this is fundamental to formulas, but I'm doing something wrong..N20 returns #VALUE! if N21 is Blank......I want to it to state: If Cell N21 is Blank, Insert 0:00:00 The existing formula that I want to add this statement to is: =ROUND(TRIM(N21)*1440,0)/60 Can anyone help? -- jeannie v |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to replace Advanced Filter | Excel Discussion (Misc queries) | |||
| Can I create an If Statement that will replace text | Excel Worksheet Functions | |||
| Search and replace chunks of html code | Excel Discussion (Misc queries) | |||
| How do I use an if statement with Find and Replace | Excel Worksheet Functions | |||
| Replace Symbol "Code(63)" | Excel Worksheet Functions | |||
Linear Mode
