Combing Functions

[Purdue15]

I have two functions IIf([NWeight]=" ",[CWeight],[NWeight]) And
Round(([CWeight]-[NWeight])/[CWeight]*100,2)

How do I combine these two together so that they can both run?

The IIf statement needs to be completed before the Round statement in the function

 

[CJ_London]

you'll need to show the context and is this being done in SQL or VBA

does the iif result substitute a value in the round function? Perhaps you are trying to get?

Round(([CWeight]-IIf([NWeight]=" ",[CWeight],[NWeight]))/[CWeight]*100,2)

 

[Purdue15]

This worked thanks!