Compare two different fields

[adonis]

Hi All

Question as follows:

There are 2 fields as follows and 3rd field which does a lookup which i named Und Price as the final output:

Und Sec Price, Lookup Price, Und Price

What i want to do is a lookup formula to provide me the price in Und Sec Price when no price or null value is available in the column in Lookup Price.

If data is available in Lookup Price, I want it to over-write the Und Sec Price.

The final output is shown in the Und Price, which would show the combination.

I was thinking of doing a case statement but how could I do that here?

Thanks
Adonis
Happy Veterans day to fellow Vets like myself.

[adonis]

i think i figured it out

If(isNull([Lookup Price]),[Und Sec Price],[Lookup Price])

amazing how lucky i can get, no need to assist apologies for inconvenience, as If statement should do the trick.

[Data Kruncher]

Hi adonis,

I saw your post today after having read Nick's about Veteran's Day.

Firstly, good to see that you've got it resolved, and secondly and more importantly, a big "Thank you" for you today.

Kruncher