Problem posting in Excel Questions - formulas truncated

micfly

Well-known Member
Joined
Sep 8, 2008
Messages
543
Not sure where to get help on this?

All of the sudden I can't post a formula without it getting truncated. This happens whether it is wrapped or not.
Any ideas? Also tried compatibility mode with no help. Using ie8. THX
 
Acutually, I just tried it in this forum and it works fine.

Code:
=IF(E8<C2*0.1,"True","False")

If I try this in Excel Questions it comes out like this:

Code:
=IF(E8<
 
put a space around any < and > characters
those are html tags and since html is enabled in Excel Questions, but not here, it causes problems there.
 
put a space around any < and > characters
those are html tags and since html is enabled in Excel Questions, but not here, it causes problems there.

Hmm, okay, seems to work...makes the formula look funny, though :)
 
I believe you can also put your formula in the php tags (instead of code tags):
PHP:
=IF(E8<C2*0.1,"True","False")

It also works to use HTML entities (if you enjoy the details involved):
Code:
=IF(E8<C2*0.1,"True","False")
 
Code tags usually work for me. I use them whenever I have the "greater than" or "less than" signs in formulas.
 
The code tags have always worked for me. I was thinking the board was going through some changes and this might be temporary.
You would think the code tags code handle displaying the code?
 
can you test with code tags again? I tried in Excel Questions earlier and it wasn't working for me
 
Doesn't work for me in Excel Questions either (without corrective measures such as spaces). That was always the case, AFAIC.

Note: it's the less than sign that gets you in trouble, I think. Greater thans are okay.
 

Forum statistics

Threads
1,213,563
Messages
6,114,332
Members
448,566
Latest member
Nickdozaj

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top