# Tearing my hair out all night with this spreadsheet...HELP Me Pls....

#### rippedit123

##### New Member
Hi everyone,

I've started off a little project since Friday to create a spread-bet spreadsheet and mostly it seems to be almost there, but there are a few major formulas that I can't get my head around and would much appreciate it if someone could please help me with this.

Here is what the spreadsheet currently looks like (Ignore the colours which have been set using conditional formatting:-

As you can see from above, there is a problem with:-

1. Cells under I. If the market has gone in my favour i.e. I chose SELL and market goes SELL and VICE versa, then that should be a WIN. But my profit for Asset Germ 30 is showing as a loss of -£20.20 in cell I6....this should show as £20.20 automatically. Also as you can see, cell E3 shows -130 points, and because the market went opposite direction, this is showing correctly as a loss in cell J, however cell I2 is showing blank, when it should be showing a loss of £13.

2. Cells under J. Currently it shows a loss even if I've got a break-even. FYI, I want to show the following text dependant on choices between cells under G, H & E: "WIN", "LOSS","BREAK-EVEN" or "N/A". So for example:-
a)If cell G & H have equal text then this is a "WIN",
b)otherwise it's a "sell"...
c)If cells G & H are blank then it should say "N/A"
d)However, if Cell E (Pips Moved) is Zero, then show "Break-Even".

I hope I have explained myself as best as possible, but to help you further, please find the formulas I used (Apologies as they may/may not be correct):-

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

#### rippedit123

##### New Member
Sorry about that...I was trying to edit the post

Replies
2
Views
638
Replies
55
Views
3K
Replies
0
Views
481
Replies
0
Views
1K
Replies
1
Views
945

1,195,623
Messages
6,010,749
Members
441,567
Latest member
Flitbee

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back