can i use as like =IF(F100.25,MROUND(F10,0.5),0)&IF(F100.2

February 28, 2013 at 03:22:43
Specs: Windows XP

is it RIGHT? Can I use this like formula which brings decimal saperation

See More: can i use as like =IF(F100.25,MROUND(F10,0.5),0)&IF(F100.2

February 28, 2013 at 08:04:59
I'm not quite sure what you are trying to do with that formula. It's the Concatenation Operator (&) that confuses me. I know what it does, but I don't know why you are using it.

The 2 conditions for your IF's are >.25 and <.25.

I tried these actual values, and got the associated results:

      F          G
10   .24        00.25
11   .25        00
12   .26        0.5

I should note that the returned values are Text values because of the Concatenation Operator. Depending on what you plan to do with those values, the fact that they are Text may cause problems.

What exactly are you trying to do with this formula?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question