**Question description:**

*This user has given permission to use the problem statement for this blog.*

I have IF function formula that doesn't calculate the end result correctly

Solved by T. J. in 28 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
09/07/2018 - 04:36

Welcome to excelchat.

User
09/07/2018 - 04:37

Am I speaking to someone?

Excelchat Expert
09/07/2018 - 04:37

Yeah, you are indeed.

User
09/07/2018 - 04:37

Hello

User
09/07/2018 - 04:37

I have a file I can upload

Excelchat Expert
09/07/2018 - 04:37

Hi, nice to have you here among us.

User
09/07/2018 - 04:37

But can't be shared of course

Excelchat Expert
09/07/2018 - 04:37

To upload a file, please click on the paperclip icon.

Excelchat Expert
09/07/2018 - 04:38

I understand that you data is sensitive.

Excelchat Expert
09/07/2018 - 04:38

You can share dummy data in stead.

User
09/07/2018 - 04:38

OK

Excelchat Expert
09/07/2018 - 04:39

Thanks, I'm waiting...

User
09/07/2018 - 04:39

sorry where do I upload it

User
09/07/2018 - 04:39

it'a a bit unclear

Excelchat Expert
09/07/2018 - 04:40

You can paste data in the preview sheet.

Excelchat Expert
09/07/2018 - 04:40

Alternatively you can send me a file directly by clicking on the paperclip icon.

User
09/07/2018 - 04:41

ok now

User
09/07/2018 - 04:42

2nd raw

Excelchat Expert
09/07/2018 - 04:42

Hmm, I'm listening...

User
09/07/2018 - 04:42

up to 125%b

User
09/07/2018 - 04:42

doesn't calculate propertly

Excelchat Expert
09/07/2018 - 04:43

I need a little more info, what are we calculating again?

User
09/07/2018 - 04:44

2nd raw up to 125%

User
09/07/2018 - 04:44

if function

User
09/07/2018 - 04:44

957
2,290
3,750

User
09/07/2018 - 04:44

2 numbers above are correct

User
09/07/2018 - 04:44

but the last one should be 503

User
09/07/2018 - 04:45

what it does it's taking the whole value up to 3750

User
09/07/2018 - 04:45

it doesn't calculate the difference

Excelchat Expert
09/07/2018 - 04:45

I'm sorry, difference of what and 125% of what?

User
09/07/2018 - 04:46

100% is 15,000

User
09/07/2018 - 04:46

125% is 18370

User
09/07/2018 - 04:47

I don't know if you can see formulas

Excelchat Expert
09/07/2018 - 04:47

I'm not able to see formula's.

User
09/07/2018 - 04:47

i see that time is running out

User
09/07/2018 - 04:48

is there any other way to do this?

Excelchat Expert
09/07/2018 - 04:48

Please send me the excel file directly.

Excelchat Expert
09/07/2018 - 04:49

We can extend time upto 1 hour if needed and unfortunately the chat box is the only way of communication.

User
09/07/2018 - 04:49

so where do I send it

Excelchat Expert
09/07/2018 - 04:49

click on the paperclip icon to upload a file which will be sent to me.

User
09/07/2018 - 04:50

ok

Excelchat Expert
09/07/2018 - 04:52

I'm waiting for the file...

Excelchat Expert
09/07/2018 - 04:52

Also you will be asked shortly to extend time, please select YES to extend.

Excelchat Expert
09/07/2018 - 04:55

Hello... Have you selected YES?

Excelchat Expert
09/07/2018 - 05:01

Hello, if you are there, you can reply in the preview window.

Excelchat Expert
09/07/2018 - 05:01

And you also can copy paste the formula there.

Excelchat Expert
09/07/2018 - 05:04

I guess you are not present.

Excelchat Expert
09/07/2018 - 05:04

Since I don't have adequate information and you are not also there, I'' close this chat now.

Excelchat Expert
09/07/2018 - 05:04

Have a great day!

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*