Seems to be a bug with the "<" sign

MrKowz

Well-known Member
Joined
Jun 30, 2008
Messages
6,653
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Was just posting over in the questions forums, trying to post the following line:

=IF(A2+30 <TODAY(),"PAST DUE","")

Notice the extra space after the A2+30... I had to put that there, otherwise the board was automatically truncating it to

=IF(A2+30

Any ideas on how to bypass this little bug aside from adding the space?

Also, the bug seems to randomly happen sometimes. It has happened to me in the past, and I have seen it happen with other people's posts.
 
Its been a known problem. You can put your formula in php tags, but when you go to edit it at any time it will not be there.

PHP:
=IF(A2+30<TODAY(),"PAST DUE","")
You just have to put this without the asterisk:

[php*]code[/php*]

Hope that helps.
 
Keith

I suppose it is a problem but it's not a bug.

That's just the way the board software deals with that character, I think it regards it as the opening of a HTML or PHP or BB or something tag.:)
 

Forum statistics

Threads
1,221,581
Messages
6,160,630
Members
451,661
Latest member
hamdan17

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