sell

I am trying to develop a formula that can give me the cost price by inputting the sell price and Return of Investment (ROI) My sell price is $20.00 I want to input a ROI of 20% and have the result be my desired cost. https://www.screencast.com/t/5hhKZVjMNw Any help would be welcome.

=IF(AND(H14="USD",E14="USD"),"No FX Trade Needed",IF(H14=E14,"BUY", "SELL")) How can I add a new agrument to this statement? If fields H and E are left blank I dont want the value to be returned as "BUY" I would like it to be blank. I tried added IF(H13="","") but I get error messages. There...

Dear, Using excel, I want to create data base that can train my employees to give alternative products to clients....in other words, if my employee wants to sell a blue pen and he didn't find it in store, the database will help him to give alternative options to sell instead with picture to...

i buy and sell 4 items no more, the problem is the items prices changes everytime i buy it. let's say one of the items is a "sugar" ... i bought it yesterday for 1$ for 1kilo and i bought 50, then after a week 2$ for 1 kilo and i bought 50 etc... when i sell 30, it costs me 30$ cuz it came from...

hello, got a goofy one here. I need to include a count of items in a subtotal, that is listed on each line of the subtotal, including the rollup itself, without factoring the summary data: <tbody> Tranaction account security price broker shares BlockNumber need to return value in Buy BLOCK...

A (Stock) Facebook Amazon Netflix Google Facebook Google B (Action) Buy Sell Sell Buy Sell Sell C (Quantity) 100 50 75 100 100 50 D (Price) 150 1000 150 1000 175 800 What's a formula if I wanted to see how much I spent on buying just google? (Google + Buy -> Quantity * Price) Thank you!

Hi Peoples; - I'm sure there is a simple way around this - please help me find it! A block of data cells (B4:BC27) contain either "FALSE" or "TRUE", and the individual column headers (B3:BC3) may be labelled "Buy" or "Sell"... Req. is to highlight all "Buy & TRUE" in one colour and all...

Is there a command to copy values and update the destination range in case the values changes? Like I have a list of items that i sell everyday. Now not all of it are sold everyday, sometimes some of the items only in the list. What I what is something that will automatically copy the items that...

Hey everyone - I got a tricky one for you today! I have a set of data that is summarized on a separate tab. The outputs on this tab CAN NOT change On this separate tab I also have 3 cells that I need to run a "What if" scenario on This equation would tell me the impact of a metric/output if a...

Hello, I need help with some macro. I would like to have in one sheet change macro which will erase one cell if one cell will be change. For example: if sell G4 will be changed then the contain of the cell O5 will be erase. Thank you.

I am trying to write a formula that will multiply the value in cell I15 by 5 if that cell is at 20 or more, and if cell I16 is equal to or higher than 105.95 and display the result in cell K15 In other words, I input 19 or less into cell I15, K15 shows 0 I input 20 into cell I15 and if cell...

I would like a quick and easy formula to help calculate profit. Scenario. Suppose I purchased 100 Iphone8 at $1000 each plus 15% tax. In excel: A1=100 B1=$1000.00 C1=15% I tried to sell them and nobody would pay me over $1000.00 for them. So I looked around and found another provider that...

I have the following on my worksheet (I excluded columns that don't matter for this problem). I want to make to unique hardcoded lists to the right of the main list (bolded). <tbody> C T U W X Y AA AB AC 1 Name Action Value Name Action Value Name Action Value 2 A Buy...

I have a project that I am trying to work on for the owner of a contracting business and have some confusion on how to work this out. I work with electrical contractors to buy wire... The price of these products are directly related to the market. However, the only thing I have to start with...

I have a spreadsheet that lists a number of items, the second columns says if it will be Sold or Purchased and then the third column has a value. I would like to create a list that takes all the "Sell" from the list above and lists them with the value in the column next to the name. I am...

Hey my fellow celly nerds, I'm wondering if you can help out. I need 4 simple, but related formulas. I uploaded a screenshot of the first page of my data here for you to quickly glance at first, if you would. http://we.tl/1n6sJdBRot It's just a wetransfer.com link, since there's no "browse"...