Spreadsheet: 772239d1647102367-named-manager-formula-not-producing-result-sbd-price-list-2022
Sheet: Honeycomb Openview

 |  |  | HONEYCOMB OPENVIEW MAINS POWERED COST PRICE |  |  |  |  |  |  |  |  |  |  | HONEYCOMB OPENVIEW MAINS POWERED PROFIT |  |  |  |  |  |  |  |  |  |  | HONEYCOMB OPENVIEW MAINS POWERED SALE PRICE
Price |  |  |  | 600 | 800 | 1000 | 1200 | 1400 | 1600 | 1800 | 2000 | 2200 |  |  | 600 | 800 | 1000 | 1200 | 1400 | 1600 | 1800 | 2000 | 2200 |  |  | 600 | 800 | 1000 | 1200 | 1400 | 1600 | 1800 | 2000 | 2200
[NAME] |  |  | 500 | 298.47 | 316.38 | 332.63 | 350.63 | 367.56 | 385.16 | 402.43 | 418.19 |  |  | 500 |  |  |  |  |  |  |  |  |  |  | 500
Length |  |  | 1000 | 327.42 | 346.6 | 364.1 | 383.35 | 401.54 | 420.4 | 438.93 | 455.95 |  |  | 1000 |  |  |  |  |  |  |  |  |  |  | 1000
Blind | =IF(AND(mylen_honcomb_opvw_1>=MIN(mycol_honcomb_opvw_moto),mywid_honcomb_opvw_1>=MIN(myrow_honcomb_opvw_moto)),IFERROR(INDEX(myrng_honcomb_opvw_moto,[NAME],INDEX(,MATCH(TRUE,INDEX(>=mylen_honcomb_opvw_1,0),0),MATCH(TRUE,INDEX(myrow_honcomb_opvw_moto>=mywid_honcomb_opvw_1,0),0)),""),"") |  | 1500 | 356.38 | 376.81 | 395.57 | 416.08 | 435.53 | 455.64 | 475.43 | 493.7 |  |  | 1500 |  |  |  |  |  |  |  |  |  |  | 1500
 |  |  | 2000 | 385.33 | 407.02 | 427.04 | 448.81 | 469.51 | 490.89 | 511.93 | 531.46 |  |  | 2000 |  |  |  |  |  |  |  |  |  |  | 2000
[NAME] |  |  | 2500 | 414.29 | 437.23 | 458.51 | 481.53 | 503.5 | 526.13 | 548.43 | 569.22 |  |  | 2500 |  |  |  |  |  |  |  |  |  |  | 2500
Length |  |  | 3000 | 443.24 | 467.45 | 489.98 | 514.26 | 537.48 | 561.37 | 584.92 | 606.97 |  |  | 3000 |  |  |  |  |  |  |  |  |  |  | 3000
Blind |  |  | 3500 | 472.2 | 497.66 | 521.45 | 546.99 | 571.47 | 596.61 | 621.42 | 644.73 |  |  | 3500 |  |  |  |  |  |  |  |  |  |  | 3500
 |  |  | 4000 | 501.15 | 527.87 | 552.92 | 579.72 | 605.45 | 631.85 | 657.92 | 682.49 |  |  | 4000 |  |  |  |  |  |  |  |  |  |  | 4000
[NAME]
Length |  |  | HONEYCOMB OPENVIEW BATTERY POWERED COST PRICE |  |  |  |  |  |  |  |  |  |  | HONEYCOMB OPENVIEW BATTERY POWERED PROFIT |  |  |  |  |  |  |  |  |  |  | HONEYCOMB OPENVIEW BATTERY POWERED SALE PRICE
Blind
 |  |  |  | 600 | 800 | 1000 | 1200 | 1400 | 1600 | 1800 | 2000 | 2200 |  |  | 600 | 800 | 1000 | 1200 | 1400 | 1600 | 1800 | 2000 | 2200 |  |  | 600 | 800 | 1000 | 1200 | 1400 | 1600 | 1800 | 2000 | 2200
 |  |  | 500 | 322.21 | 340.13 | 356.38 | 374.37 | 391.31 | 408.91 | 426.17 | 441.94 |  |  | 500 |  |  |  |  |  |  |  |  |  |  | 500
 |  |  | 1000 | 351.17 | 370.34 | 387.85 | 407.1 | 425.29 | 444.15 | 462.67 | 479.69 |  |  | 1000 |  |  |  |  |  |  |  |  |  |  | 1000
 |  |  | 1500 | 380.12 | 400.56 | 419.32 | 439.83 | 459.27 | 479.39 | 499.17 | 517.45 |  |  | 1500 |  |  |  |  |  |  |  |  |  |  | 1500
 |  |  | 2000 | 409.08 | 430.77 | 450.79 | 472.55 | 493.26 | 514.63 | 535.67 | 555.21 |  |  | 2000 |  |  |  |  |  |  |  |  |  |  | 2000
 |  |  | 2500 | 438.03 | 460.98 | 482.26 | 505.28 | 527.24 | 549.87 | 572.17 | 592.96 |  |  | 2500 |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  | 3000 | 466.99 | 491.19 | 513.73 | 538.01 | 561.23 | 585.12 | 608.67 | 630.72 |  |  | 3000 |  |  |  |  |  |  |  |  |  |  | 3000
 |  |  | 3500 | 495.94 | 521.41 | 545.19 | 570.73 | 595.21 | 620.36 | 645.17 | 668.48 |  |  | 3500 |  |  |  |  |  |  |  |  |  |  | 3500
 |  |  | 4000 | 524.9 | 551.62 | 576.66 | 603.46 | 629.2 | 655.6 | 681.67 | 706.23 |  |  | 4000 |  |  |  |  |  |  |  |  |  |  | 4000
USING MORE EXPENSIVE BATTERY OPERATED AS THE PRICE FOR BOTH