Vlookup, IF exercise
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTU
1
Fruits Purchase priceSelling pricePieces in stockPurchase ValueSelling ValueIF Selling price < Purchase price
IF Selling price < Purchase price and i have less than 10 pieces
2
Apple101610
3
Apricot121913
4
Avocado81215
5
Banana587
6
Bilberry10168
7
Blackberry182820
8
Blackcurrant81210
9
Blueberry5813
10
Boysenberry121115
11
Currant10167
12
Cherry11178
13
Cherimoya282820
14
Cloudberry19298
15
Coconut16168
16
Cranberry182110
17
Cucumber192213
18
Custard apple202215
19
Damson21237
20
Date21238
21
Dragonfruit222420
22
Durian232510
23
Elderberry242513
24
Feijoa242615
25
Fig25267
26
Goji berry26278
27
Gooseberry272820
28
Grape28288
29
Grapefruit28298
30
Guava292910
31
Honeyberry303013
32
Huckleberry313115
33
Jabuticaba31317
34
Jackfruit32328
35
Jambul333220
36
Jujube343310
37
Juniper berry353413
38
Kiwi353415
39
Kumquat36357
40
Lemon37358
41
Lime383620
42
Loquat38368
43
Longan39378
44
Lychee403810
45
Mango413813
46
Marionberry423915
47
Melon42397
48
Miracle fruit43408
49
Mulberry444120
50
Nectarine454110
51
Nance464213
52
Olive464215
53
Orange47437
54
Papaya48448
55
Passionfruit494420
56
Peach49458
57
Pear50458
58
Persimmon514610
59
Physalis524613
60
Plantain534715
61
Plum53487
62
Pineapple54488
63
Plumcot554920
64
Pomegranate564910
65
Pomelo565013
66
Purple mangosteen575115
67
Quince58517
68
Raspberry59528
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...