Hey there! Sign in to join this conversationNew here? Join for free

I am screwed Watch

Announcements
    • Thread Starter
    Offline

    14
    ReputationRep:
    hi...
    i am struggling a bit with my spreadsheet task!
    so i have 3 worksheet
    1- costs- that has all the data in e.g. tables
    2- quotation- where the user add the information and workout the total cost
    3- breakdown- this is where the quotation (total) cost come from...
    i have used if statement to workout the cost per day, discount but it only works for 90 days (user can hire the van from 3 to 90 days) but it won't work if the user wants to hire for 33 days
    so i want to just ask for some guidance that how can i use "if and vlookup" statement to make it all work!
    i tried this formula but it didn't work
    =IF(C4 = "Low" VLOOKUP(Quotation!F13, Costs!$G$5: $H$15,2,FALSE))
    It's due tomorrow :cry:
    Offline

    21
    ReputationRep:
    (Original post by fatima1998)
    hi...
    i am struggling a bit with my spreadsheet task!
    so i have 3 worksheet
    1- costs- that has all the data in e.g. tables
    2- quotation- where the user add the information and workout the total cost
    3- breakdown- this is where the quotation (total) cost come from...
    i have used if statement to workout the cost per day, discount but it only works for 90 days (user can hire the van from 3 to 90 days) but it won't work if the user wants to hire for 33 days
    so i want to just ask for some guidance that how can i use "if and vlookup" statement to make it all work!
    i tried this formula but it didn't work
    =IF(C4 = "Low" VLOOKUP(Quotation!F13, Costs!$G$5: $H$15,2,FALSE))
    It's due tomorrow :cry:
    I had been playing around with those formulas for about two years. But now that I no longer use them, I have barely any idea what they are used for. But anyway, I'll provide you with a link that'll be helpful:
    http://www.techonthenet.com/excel/formulas/

    And here is the site I used when I was doing ICT in school:
    http://www.teach-ict.com/index.html

    Hope that helps...
 
 
 
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • Poll
    Should Spain allow Catalonia to declare independence?
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

    Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

    Quick reply
    Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.