Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 04, 2017 at 08:32 PM

    try this.

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

    Add comment
    10|10000 characters needed characters exceeded