Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

how should I write if function here to have if the in stock is enough it calculates cost unit *units, if not =0.how should I

how should I write if function here to have if the in stock is enough it calculates cost unit *units, if not =0.how should I write vlook up if the in stock is enough? In stock is in other sheet and I just wanna general formula.

image text in transcribed
DIRECT MATERIALS Req.No. Item Code Details/Description Quantity Cost/Unit Amount 223 M1021 MGX 8025 Chip Set 3 110.90 121) 224 R1004 Robot Kit 38G 3,288.90 228 R1024 Relays - Medium Pack 274.80 225 51009 Servo Motors B21 (4 pack) 1,051.20 225 $1010 Servo Motors A21 (8 pack) 1,995.00 225 S1014 SMC Pneumatic Part X-33 Of W W W W 748.60

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

Excel Applications For Accounting Principles

Authors: Gaylord SmithBruce Walz

4th Edition

1133388027, 9781133388029

More Books

Students also viewed these Accounting questions

Question

Which of our faculty members would you like to work with?

Answered: 1 week ago

Question

3. It is the commitment you show that is the deciding factor.

Answered: 1 week ago