x Turn on thread page Beta
 You are Here: Home

I am screwed watch

Announcements
1. hi...
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
2. (Original post by fatima1998)
hi...
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
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...

TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: January 14, 2016
Today on TSR

Loughborough better than Cambridge

Loughborough at number one

Can I date a girl with no boobs?

Poll
Useful resources

Can you help? Study Help unanswered threadsStudy Help rules and posting guidelines

Groups associated with this forum:

View associated groups

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