Results 1 to 7 of 7

Excel (value) error question.

Threaded View

  1. #1
    Registered User
    Join Date
    11-02-2008
    Location
    Columbia
    Posts
    4

    Excel (value) error question.

    I am trying to figure pricing based on qty and height x length, but also have the value subject to a minimum. So in this example I have a quantity 4 with the length (3) x height (2). The price is based on another formulas that takes the 6 x 1.20 to give you the 7.2 but the minimum charge is 10.00.
    I created the formula below, but it gives me an value error. If anyone could help point me in the right direction, it would be great.



    QTY LENGTH HEIGHT TOTAL SIZE
    4 3 2 6


    CHARGE PER FORMULA CHARGE SUBJECT TO MINIMUM
    7.2 #VALUE!


    =IF(A4<3,E4<10,10),IF(A4<11,E4<8,8),IF(A4<35,E4<7.5,7.5),IF(A4<71,E4<7.25,7.25),IF(A4<143<6.5,6.5)
    Last edited by VBA Noob; 11-03-2008 at 03:38 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1