Hey there! Sign in to join this conversationNew here? Join for free
x Turn on thread page Beta
 You are Here: Home >< A-levels

# ICT- IMMEDIATE HELP please watch

1. 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))
this formula is for one... i have to do 3 more but this one isn't working
2. (Original post by fatima1998)
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))
this formula is for one... i have to do 3 more but this one isn't working
Answered on the other thread

Reply
Submit reply
Turn on thread page Beta
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

### Any tips for freshers...

who are introverts?

### Buying Cookies? Read this!

Discussions on TSR

• Latest
Poll
Help with your A-levels

## All the essentials

### Student life: what to expect

What it's really like going to uni

### Essay expert

Learn to write like a pro with our ultimate essay guide.

### Uni match

Our tool will help you find the perfect course for you

### Create a study plan

Get your head around what you need to do and when with the study planner tool.

### Resources by subject

Everything from mind maps to class notes.

### Degrees without fees

Discover more about degree-level apprenticeships.

### Study tips from A* students

Students who got top grades in their A-levels share their secrets

## Study help links and info

Can you help? Study help unanswered threadsRules and posting guidelines

## Groups associated with this forum:

View associated groups
Discussions on TSR

• Latest

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.