Hey there! Sign in to join this conversationNew here? Join for free
x Turn on thread page Beta
    • Thread Starter
    Offline

    15
    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...
 
 
 
Reply
Submit reply
Turn on thread page Beta
Updated: January 14, 2016
Poll
Do you agree with the proposed ban on plastic straws and cotton buds?

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

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