View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Greg Lovern Greg Lovern is offline
external usenet poster
 
Posts: 224
Default Formatting in formulas not allowed before commas

If I format a formula with carriage returns and spaces for clarity,
any carriage returns or spaces right before a comma are removed by
Excel. For example, if I do this:
(Yes, I realize this formula doesn't make sense; it's just a simple
example to illustrate the problem.)

=IF(
OR(
TRUE,TRUE
)
,TRUE,TRUE
)

As soon as press Enter, Excel changes it to this:

=IF(
OR(
TRUE,TRUE
),TRUE,TRUE
)

That happens with carriage returns right before commas, spaces right
before commas, and any combination of them right before commas.

Is there any way around that? The best I've been able to do is just do
the formatting after the comma instead of before it:

=IF(
OR(
TRUE,TRUE
),
TRUE,TRUE
)


Thanks,

Greg