Function Arguments Display Distortion

[Manos50]

Can anyone explain why this display distortion happens when entering multiple arguments?

Capture.JPG

This is an If / Or formula and this distortion happens after the third value ...
I start with the IF formula. Then at the "logical_test" field I insert the OR function.
Then inserting a value at the Logical1, Logical2, Logical3 ... the distortion appears...
Excel 2010 ver. 14.0.7147.5001 (32-bit) / Windows 7 Home Premium 64bit

[Nisha Dhawan]

Hi Manos,

I tried the same but I don't see anything on my system. Could you attach something, some sample workbook to check further??

Also, It seems you are using OR not IF

1.jpg

[Manos50]

Hi Nisha,

Thanks for your reply.

I am using a COMBINATION of If + Or functions.

I start with the "If function".

Then at the Logical1 of the "If Function" I insert the "Or Function".

After the third value "Logical3" the table distorts ...

Capture.JPG

If I use ONLY the "Or function" there is no distortion, like on your system.

Capture 1.JPG

What exactly could I attach to reproduce this issue on your system? It is not an Excel sheet problem ...

[Andy Pope]

The whole formula might help rather than the smaller inner sections.

[Manos50]

Can you reproduce that specific layout on your system?

I am asking you because I have seen the same problem on other computers running Office 2010.

Thanks

[Manos50]

Can you reproduce that specific layout on your system?

I am asking you because I have seen the same problem on other computers running Office 2010.

Thanks

[Andy Pope]

We probably can *IF* you give us the formula.

[newdoverman]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

A description of your computer would also be of value as this could very well be a matter of too little graphics power not allowing the monitor to refresh properly.

[joeu2004]

Can anyone explain why this display distortion happens when entering multiple arguments?
Attachment 392037
This is an If / Or formula and this distortion happens after the third value ...
I start with the IF formula. Then at the "logical_test" field I insert the OR function.
Then inserting a value at the Logical1, Logical2, Logical3 ... the distortion appears...
Excel 2010 ver. 14.0.7147.5001 (32-bit) / Windows 7 Home Premium 64bit

Also see the discussion of the same problem at http://answers.microsoft.com/en-us/office/forum/office_2010-excel/function-arguments-display-distorted/b008e60e-3a56-4f88-9956-a3ab2d7aee7f (click here)

And duplicate discussion in this forum at http://www.excelforum.com/excel-formulas-and-functions/1081198-function-arguments-display-distortion-bug.html (click here).

[Manos50]

NO Need to use a formula. Just move the cursor inside the Function Arguments Table.

[Manos50]

A description of my steps.

New Workbook. Cell A1 > Insert Function > Choose IF

Capture 1.JPG

IF Function Arguments Window:

Capture 2.JPG

Logical_test > Insert function OR:

Capture 3.JPG

Continue to Logical2 of the OR function:

Capture 4.JPG

Continue to the Logical3 of the OR function. The distortion appears ...

Capture 5.JPG

Windows 7 Home Premium 64 bit - Intel Core i7-3820 - RAM 12GB - NVIDIA GEForce GTX 760 4038 mb

[newdoverman]

I can't reproduce your problem.

[Andy Pope]

I can not repo either with exactly the same excel version

[newdoverman]

Most (nearly all) distortion problems that I have seen are due to hardware not being up to the task of redrawing the screen properly.