Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do I create an if statement in column O if revenues are great than one million dollars? if True = Larger Order if False

image text in transcribedHow do I create an if statement in column O if revenues are great than one million dollars?

if True = Larger Order

if False = Small Order

L A B C D 1 Region Country Item Type Sales Channel 2 Sub-Sahar Chad Office Supplies Online 3 Europe Latvia Beverages Online 4 Middle Ea: Pakistan Vegetables Offline 5 Sub-Sahar Democrati Household Online 6 Europe Czech Rep Beverages Online 7 Sub-Sahar South Afri Beverages Offline 8 Asia Laos Vegetables Online 9 Asia China Online 10 Sub-Sahar Eritrea Meat Online 11 Central An Haiti Office Supplies Online 12 Sub-Sahar Zambia Cereal Offline 13 Europe Bosnia ani Baby Food Offline 14 Europe Germany Office Supplies Online 15 Asia India Household Online 16 Middle Ea: Algeria Clothes Offline 17 Australia a Palau Snacks Offline 18 Central An Cuba Beverages Online 19 Europe Vatican Cit Beverages Online Baby Food E F G H K L M N Order Prio Order Date Order ID Ship Date Units Sold Unit Price Unit Cost Total Reve Total Cost Total Profi Large or Small 2011-01-27 292494523 2011-02-12 4484 651.21 524.96 2920026 2353921 566105) 2015-12-28 361825549 2016-01-23 1075 47.45 31.79 51008.75 34174.25 16834.5 C 2011-01-13 141515767 2011-02-01 6515 154.06 90.93 1003701 592409 411292 2012-09-11 500364005 2012-10-06 7683 668.27 502.54 5134318 3861015 1273304 2015-10-27 127481591 2015-12-05 3491 47.45 31.79 165648 110978.9 54669.06 H 2012-07-10 482292354 2012-08-21 9880 47.45 31.79 468806 314085.2 154720.8 L 2011-02-20 844532620 2011-03-20 4825 154.06 90.93 743339.5 438737.3 304602.3 C 2017-04-10 564251220 2017-05-12 3330 255.28 159.42 850082.4 530868.6 319213.8 L 2014-11-21 411809480 2015-01-10 2431 421.89 364.69 1025615 886561.4 139053.2 2015-07-04 327881228 2015-07-20 6197 651.21 524.96 4035548 3253177 782371.3 M 2016-07-26 773452794 2016-08-24 724 205.7 117.11 148926.8 84787.64 64139.16 M 2012-10-20 479823005 2012-11-15 9145 255.28 159.42 2334536 1457896 876639.7 2015-02-22 498603188 2015-02-27 6618 651.21 524.96 4309708 3474185 835522.5 2016-08-27 151717174 2016-09-02 5338 668.27 502.54 3567225 2682559 884666.7 C 2011-06-21 181401288 2011-07-21 9527 109.28 35.84 1041111 341447.7 699662.9 L 2013-09-19 500204360 2013-10-04 441 152.58 97.44 67287.78 42971.04 24316.74 . 2015-11-15 640987718 2015-11-30 1365 47.45 31.79 64769.25 43393.35 21375.9 2015-04-06 206925189 2015-04-27 2617 47.45 31.79 124176.7 83194.43 40982.22

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Ultra High Net Worth Bankers Handbook

Authors: Heinrich Weber, Stephan Meier

1st Edition

1905641753, 978-1905641758

More Books

Students also viewed these Finance questions