Pages: 1

 

2006-09-28 07:13:55
sgt_rambo35
Banned
+5|6913
ok , im on a project to make an invoice ordering system. I am working on combo boxes at the moment, i have two options "AMD" and "Intel" which links to named tables on sheet2. My problem is this formula workscorrectley for the first 3 produts , then on the 4th it says #value! ? How can that be if its an exact  formula.

=IF($O$8=1,"Choose Processor",IF($O$8=2,+INTEL,IF($O$8=3,AMD)))

        ^ Link cell 1 for combo1                          ^ tables on sheet 2^

I want it to ask a combo box 1" Chooserpocessor AMD or intel, then depending on the choice combo box 2 will display the correct options for processors... I have it working but i get #value in 3 of my products in the table.

AMD Sempron 3600+ (2.2GHZ)
AMD ATHLON X2 4800+ (2.4ghz)
AMD ATHLON 64 3800+ (2.2GHZ)
#VALUE!
#VALUE!
#VALUE!


I dragged the formula down, so its 100% the same formula, which makes me think theres something wrong in the prduct table on sheet2?

PRoduct table  for amd , table named "AMD"

Processors (AMD)
AMD XP 3000+ Barton (2.16ghz)
AMD 64bit Sempron 3000+ (2.16ghz)
AMD Duron 1800+
AMD Sempron 3600+ (2.2GHZ)
AMD ATHLON X2 4800+ (2.4ghz)
AMD ATHLON 64 3800+ (2.2GHZ)

this table is called "intel"

Processors (Intel)
INTEL PENTIUM D DUAL CORE (5.3GHZ)
INTEL PENTIUM 4 670 (3.8GHZ)
INTEL PENTIUM 3 (1GHZ)
INTEL PENTIUM D (2.66GHZ)
INTEL PENTIUM 4 (2.93GHZ)
INTEL PENTIUM 4 660 (3.6GHZ)


Can anyone see where the error is? works for first 3 but then not for the last 3 :S
2006-09-28 07:18:56
Use0fWeapons
Get repairs here
+60|6981|Doncaster - UK
ok, i am going to try and copy this into excel, have a look. dont see anything wrong at first.

crap, i obviously dont remember this stuff as well as i thought....hold on though.  still looking.

Question, are you using forms, or control, combo boxs?

And where exactly are you using the formula you have posted?

Last edited by Use0fWeapons (2006-09-28 07:29:07)

2006-09-28 07:27:04
sgt_rambo35
Banned
+5|6913
lol
2006-09-28 07:32:37
sgt_rambo35
Banned
+5|6913
im using forms toolbar
, the combo box works properly, it even displays #value in it lol... just the actual input cells for the combobox dont pick up theproduct in the last 3, says #value .. confusing

its fixed itself , i changed a few things like using non caps . think that was it?

Last edited by sgt_rambo35 (2006-09-28 07:44:53)

2006-09-28 07:47:06
Use0fWeapons
Get repairs here
+60|6981|Doncaster - UK
not much luck yet, but couldn't you reduce the formula your using like so...

=IF($O$8=1,"Choose Processor",IF($O$8=2,+INTEL,AMD))

not relay fixing your problem, but i feel i must offer something. 

BTW
Do you need to do it in two tables. 
How about having the 2nd combo box always reading the same cells, and formula them to show the correct text depending on the first combo choice?
2006-09-28 07:49:27
Use0fWeapons
Get repairs here
+60|6981|Doncaster - UK
ok,
Excel is good like that.  Yesterday, i wrote the same formula on two PC's, one worked the other wouldent.  Open a new sheet, do it again, its fine.  WTF?  Sometimes i think the it Ninjas change my formula when i am not looking.
Anyhow, good luck with the project, later.
2006-09-28 07:54:15
sgt_rambo35
Banned
+5|6913
lol thanks, im just playing about learning now , building a basic one so im ready for the school project

 

Pages: 1

Board footer

Privacy Policy - © 2025 Jeff Minard