Decimal Issues In IF Formula

[kgtrader]

Hi, I have this formula: See Formula 1 in first comment (Can't post here as I get this error message with my formula: You are not allowed to post any kinds of links, images or videos until you post a few times.)


The part where it says "Value Per Pip/Point" refers to a column which has a figure with 2 decimal places e.g. 0.07
The formula above is calculating the whole figure of 0.0729571984 which is causing the calculation to be incorrect.
How do I get the formula to use the actual figure shown in the cell which is 0.07?

Thanks

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook.

[kgtrader]

I can't seem to send the formula for the above question.

[AliGW]

Please read post #2 and the instructions referred to therein.

[Kaper]

First idea - you can change accurracy of calculations to fit the displayed accuraccy in excel options
Second one - you can use ROUND function nested into your IF

a general tip (no link, no video, image (screenshot) only as a supplementary). We like receiving excel workbooks as attachments/examples/explanations - hot to attach - see at the bottom of the below text:

Please read the yellow banner at the top of the page. Or skip to extended version of it below:

Will you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If there are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, empty cells between data, mixed text/numbers, merged cells, some important cells filled with content by macro/manually/by formula, etc. - please show them all, or at least indicate in text). The use of unrepresentative data and formats is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

To attach an Excel file you have to do the following (paperclip icon does not work!): Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.

[kgtrader]

I have attached a spreadsheet to the above question.
Please let me know if that helps.

[kgtrader]

Please see attached spreadsheet below

[AliGW]

Perhaps round the amount:

=IFERROR(IF(LEFT([@Status],3)="Ope"," N/A - Open Trade",IF(OR([@Status]="",[@Status]=" - ")," - ",IF(LEFT([@Status],12)="Trade Closed",SUM([@[Points+/-]]*ROUND([@[Value Per Pip/Point]],2),[@[Mics Adjustment]]),"N/A - Check Row Inputs"))),"N/A - Check Row Inputs")

[Kaper]

This is what I ment in post #5 by ROUND nesting:

Please Login or Register  to view this content.

[kgtrader]

@AliGW

Thank you so much, this has resolved my issue :-)

[kgtrader]

@Kaper

Thanks a lot, this has helped to resolve my issue and thanks for the spreadsheet too :-)

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Administrative Note:

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below or the REPLY button instead of REPLY WITH QUOTE.

[kgtrader]

Ok I'll do that next time.

Thanks