• 463K Members
• 8,330 Online
• 560K Conversations
SOLVED

New Contributor

# Urgent help with formula

I am doing assignment for school and stuck at one question. Its distance study, so contacting instructor is not an option.

Question is: I made 3 new column on sheet of inventory, In first column I have to change the price to reflect discount of 24%, but only for items in stock( another column) over 100, otherwise price won't change.

Second: If quantity of stock is smaller than 80, place an order for 50, if not, order 0

Third: Assume that data values stored in Unit price column represent the wholesale price ( WP). Determine Recommended Retail Price (RRP) based on the following business rule. If WP is greater than 20, RRP will be increased by 28%. If not, RRP will be increased by 35%.

This is like way too advanced for me and have no idea where to turn.

3 Replies
Solution

# Re: Urgent help with formula

Hello Lenka,

Perhaps, the attached file will answer your assignment. Note that you can modify the values in J1:J6, without any required modification in the formulas.

Please feel free to seek any clarification that might bother your inquisitive mind.

Cheers,

Twifoo

# Re: Urgent help with formula

THANK YOU so much! I have literally finished it in 10 minutes. It worked like magic.

# Re: Urgent help with formula

You’re welcome!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies