need a formula to calculate is excel

Not open for further replies.

Joined:
Apr 1, 2012
Messages:
2
for these three conditions i need a formula

if i buy 1000 quantity at 100rs sell 700 @ 105 and 300 @ 110 what will be the profit

buy 1000 quantity at 100rs sell 700 @ 105 and 300 @ 90 what will be the profit

buy 1000 quantity at 100rs sell 700 @ 90 and 300 @ 90 what will be the net profit

these three conditions should be applied in excel in one column to calculate for these three conditions kindly help

2. etafModerator

Joined:
Oct 2, 2003
Messages:
65,202
First Name:
Wayne
is this homework question

otherwise what is the application use for this request ?

look at the IF function

Joined:
Apr 1, 2012
Messages:
2
i dont know to apply the if function for this thats why

4. etafModerator

Joined:
Oct 2, 2003
Messages:
65,202
First Name:
Wayne
probably not an if statement required -

can you provide a dummy spreadsheet where you have the numbers and how you want them presented

if you just need to calculate its a simple sum

As Seen On