Skip to Content
0

Help with If,Then,Else statement then howcome the value wont display properly?

May 04, 2017 at 07:31 PM

24

avatar image

I have a column which shows Values in ($1234.56) that is coming from [Original Number] and another value that is coming from the [Second Number].

The Formula I am using is:

If(IsNull([Original Number])) Then([Second Number]) Else([Original Number])

Unfortunately that hasn't been giving me the ([Second Number]) and for some reason keeps Showing me $0.00 which is in the [Original Number] field.

Is there a way I can change the formula to make it overlook the 0.00 value??

Thank You

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
May 04, 2017 at 08:32 PM
0

try this.

=If(IsNull([Original Number]) or ( [Original Number]=0)) Then([Second Number]) Else([Original Number])

Share
10 |10000 characters needed characters left characters exceeded