fatima1998
Badges: 15
Rep:
?
#1
Report Thread starter 3 years ago
#1
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))
0
reply
Kevin De Bruyne
Badges: 21
Rep:
?
#2
Report 3 years ago
#2
(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))
To me it seems like it is difficult to help without seeing the spreadsheets, but I don't know, it could be possible to help without them.
0
reply
fatima1998
Badges: 15
Rep:
?
#3
Report Thread starter 3 years ago
#3
(Original post by SeanFM)
To me it seems like it is difficult to help without seeing the spreadsheets, but I don't know, it could be possible to help without them.
i know!!! it is not going to be easy to explain what i am trying to do... but i am totally dead and crying... literally this task made me so cry
i don't mind sending you spreadsheet and then u can give me feedback?
0
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Back
to top

University open days

  • Regent's University London
    Postgraduate Open Evening Postgraduate
    Thu, 19 Sep '19
  • Durham University
    Pre-Application Open Days Undergraduate
    Fri, 20 Sep '19
  • Loughborough University
    Undergraduate Open Day Undergraduate
    Fri, 20 Sep '19

What's your favourite genre?

Rock (116)
24.27%
Pop (110)
23.01%
Jazz (22)
4.6%
Classical (25)
5.23%
Hip-Hop (87)
18.2%
Electronic (37)
7.74%
Indie (81)
16.95%

Watched Threads

View All