|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 7th, 2006, 01:56 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
###### Wrong Formula
Can someone tell me what I'm doing wrong? I used this formula for Cell N29: =IF(J29="","",N28+K29) The problem is if no value is yet entered into K29, I get ###### What formula can I use to resolve this problem? -- Ningster ------------------------------------------------------------------------ Ningster's Profile: http://www.excelforum.com/member.php...o&userid=36052 View this thread: http://www.excelforum.com/showthread...hreadid=559290 
|
|
#2
July 7th, 2006, 02:04 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
###### Wrong Formula
What do you want to get if K29 has no value? this will give you N28 =IF(J29="","",SUM(N28,K29)) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=559290
|
|
#3
July 7th, 2006, 02:11 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
###### Wrong Formula
I use this formula for Cell N29: =IF(J29="","",N28+K29) If no value is yet entered into K29, I want N29 to be blank instead of showing ###### -- Ningster ------------------------------------------------------------------------ Ningster's Profile: http://www.excelforum.com/member.php...o&userid=36052 View this thread: http://www.excelforum.com/showthread...hreadid=559290
|
|
#4
July 7th, 2006, 02:41 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
###### Wrong Formula
what is format are you using? What is the value of N28?
*Pasted from help* A ##### error value occurs when the cell contains a number, date, or time that is wider than the cell or when the cell contains a date and/or time formula that produces a negative result. "Ningster" wrote: Can someone tell me what I'm doing wrong? I used this formula for Cell N29: =IF(J29="","",N28+K29) The problem is if no value is yet entered into K29, I get ###### What formula can I use to resolve this problem? -- Ningster ------------------------------------------------------------------------ Ningster's Profile: http://www.excelforum.com/member.php...o&userid=36052 View this thread: http://www.excelforum.com/showthread...hreadid=559290
|
|
#5
July 7th, 2006, 03:03 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
###### Wrong Formula
I use this formula for Cell N29: =IF(J29="","",N28+K29) I think what I want is if both cell nos. J29 and K29 have no value, the formula for N29 to be blank instead of showing ###### I don't know how to do it IF(J29 and K29="","",N28+K29) Or do I need to use the AND( formula if both J29 and K29 are blank? -- Ningster ------------------------------------------------------------------------ Ningster's Profile: http://www.excelforum.com/member.php...o&userid=36052 View this thread: http://www.excelforum.com/showthread...hreadid=559290
|
|
#6
July 7th, 2006, 03:19 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
###### Wrong Formula
hi Ningster, The below shows two approaches using the AND function: =if(and(isblank(j29),isblank(k29)),"",N28+K29) or =if(and(j29="",k29=""),"",N28+K29) As Sloth mentioned the ##### effect could be caused by the values contained within the cells, what type of data is in them? hth Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=559290
|
|
#7
July 7th, 2006, 03:23 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
###### Wrong Formula
data consist of a 1-decimal number no greater than 100 -- Ningster ------------------------------------------------------------------------ Ningster's Profile: http://www.excelforum.com/member.php...o&userid=36052 View this thread: http://www.excelforum.com/showthread...hreadid=559290
|
|
#8
July 7th, 2006, 03:43 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
###### Wrong Formula
=IF((J29="")*(K29=""),"",N28+K29)
I was trying to figure out why you are getting the ###### error. If K29 contained "" you would get a #VALUE! error instead of a ######. I thought maybe N29 was formatted as a date and N28 was a negative number. That would give you a ###### error. Or having the cell to thin would also give you the ###### error. Just because a referenece cell is blank won't give you that error. "Ningster" wrote: I use this formula for Cell N29: =IF(J29="","",N28+K29) I think what I want is if both cell nos. J29 and K29 have no value, the formula for N29 to be blank instead of showing ###### I don't know how to do it IF(J29 and K29="","",N28+K29) Or do I need to use the AND( formula if both J29 and K29 are blank? -- Ningster ------------------------------------------------------------------------ Ningster's Profile: http://www.excelforum.com/member.php...o&userid=36052 View this thread: http://www.excelforum.com/showthread...hreadid=559290
|
|
#9
July 8th, 2006, 01:09 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
###### Wrong Formula
*Any* error message will produce #####, when the cell is too narrow to
display it (error msg)! -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Sloth" wrote in message ... =IF((J29="")*(K29=""),"",N28+K29) I was trying to figure out why you are getting the ###### error. If K29 contained "" you would get a #VALUE! error instead of a ######. I thought maybe N29 was formatted as a date and N28 was a negative number. That would give you a ###### error. Or having the cell to thin would also give you the ###### error. Just because a referenece cell is blank won't give you that error. "Ningster" wrote: I use this formula for Cell N29: =IF(J29="","",N28+K29) I think what I want is if both cell nos. J29 and K29 have no value, the formula for N29 to be blank instead of showing ###### I don't know how to do it IF(J29 and K29="","",N28+K29) Or do I need to use the AND( formula if both J29 and K29 are blank? -- Ningster ------------------------------------------------------------------------ Ningster's Profile: http://www.excelforum.com/member.php...o&userid=36052 View this thread: http://www.excelforum.com/showthread...hreadid=559290
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Is it possible? | DakotaNJ | Worksheet Functions | 25 | September 18th, 2006 09:30 PM |
| Dynamic Range with unused formula messing up x axis on dynamic graph | [email protected] | Charts and Charting | 2 | February 2nd, 2006 08:02 PM |
| Updating data makes formula wrong | a_moron | General Discussion | 4 | January 27th, 2006 08:03 AM |
| Match then lookup | Tenacity | Worksheet Functions | 10 | December 3rd, 2005 05:30 AM |
| Formula Problem - interrupted by #VALUE! in other cells!? | Ted | Worksheet Functions | 17 | November 25th, 2005 05:18 PM |
Linear Mode
