Access help converting an ecxel formula into a access query function?
my excel formula:
=IF(F11="Yes", IF(K11="",
IF(42400/G11<3000/H11,
42400/G11, 3000/H11)),
IF(L11="", IF(K11*26
K11*26, K11*(42400/(G11*K11)), L11*K11),
IF(K11="", IF(44000/G11<3000/H11,
44000/G11, 3000/H11)), IF(L11="",
IF(K11*26
K11*(44000/G11*K11)), L11*K11)))
if you can write this as it should be entered in access please help, just use the cells as the fieldnames, I can make the conversions...i.e. cell K11 would be [K11] in access
p.s....if you try to put formula in excel, it won't work, I know it has too many operators, some of the "if x use this query "select From Diode Dynamics H11b HID Conversion Kit Installation Demo Thanks for visiting!
IIF(F11<>0, IIF(K11="", IIF(42400/G11<3000/H11, 42400/G11, 3000/H11)),
IIF(L11="", IIF(K11*26
K11*26, K11*(42400/(G11*K11)), L11*K11),
IIF(K11="", IIF(44000/G11<3000/H11,
44000/G11, 3000/H11)), IIF(L11="",
IIF(K11*26
K11*(44000/G11*K11)), L11*K11))) as result
Whats On My YouTube Today?
Here Are A Few Items From Amazon You Might Be Interested In.

XENTEC H11 (H8/H9) 8000K HID Slim Ballast HID Xenon Kit (Iceberg Blue) offroad
List Price: $60.00
Sale Price: $34.99
You save: $25.01 (42%)
Eligible for free shipping!
Availability: Usually ships in 1-2 business days

Kensun HID Xenon Conversion KIT Digital Slim Ballast H11 6000k (Diamond Blue)
List Price: $249.99
Sale Price: $85.99
You save: $164.00 (66%)
Eligible for free shipping!
Availability: Usually ships in 1-2 business days

Kensun HID Xenon Conversion KIT H11 4300k (Ultra White)
List Price: $249.99
Sale Price: $79.99
You save: $170.00 (68%)
Eligible for free shipping!
Availability: Usually ships in 1-2 business days

Kensun HID Xenon Conversion Kit "All Bulb Sizes and Colors" with "Slim" Digital Ballasts - H11 - 4300k
List Price: $259.99
Sale Price: $71.59
You save: $188.40 (72%)
Eligible for free shipping!
Availability: Usually ships in 1-2 business days

JLM Standard HID Conversion Kit H11(H8/H9) 3000K in Retail Box Offroad (Golden Yellow)
List Price: $199.99
Sale Price: $42.99
You save: $157.00 (79%)
Eligible for free shipping!
Availability: Usually ships in 1-2 business days

KENSUN HID Xenon Conversion Kit Digital Slim Ballast H11 8000k (Thunder Blue)
List Price: $249.99
Sale Price: $85.99
You save: $164.00 (66%)
Eligible for free shipping!
Availability: Usually ships in 1-2 business days

Kensun HID Xenon Conversion Kit with "Slim" Digital Ballasts - H11 - 8000k
List Price: $155.99
Sale Price: $55.55
You save: $100.44 (64%)
Eligible for free shipping!
Availability: Usually ships in 1-2 business days

H11 Relay Harness For Xenon HID Conversion Kit
List Price: $29.99
Sale Price: $4.99
You save: $25.00 (83%)
Eligible for free shipping!
Availability: Usually ships in 1-2 business days

Xentec HID Conversion Kit H11 8000k Single Beam Xenon (Thunderblue)
Sale Price: $37.99
Eligible for free shipping!
Availability: Usually ships in 1-2 business days

KENSUN HID Xenon Conversion Kit H11 - 6000k (Bright White with a tint of Blue Color) With slim Ballasts
List Price: $259.99
Sale Price: $69.99
You save: $190.00 (73%)
Eligible for free shipping!
Availability: Usually ships in 1-2 business days
Items recently purchased on this site:

















































































