Using IF to determine which sum to use

User: "Altair Forum User"
Altair Employee
Updated by Altair Forum User

Hi,

 

I'm trying to use an if statement as I would in Excel, but not getting anywhere. This is my formula. They are all numeric fields.

 

 

IF(([Total Amount]*[Exchange Rate])=0,[Total Amount],[Total Amount]*[Exchange Rate])

 

Does anyone have an idea please? I'm using classic.

 

Thanks

Natalie

Find more posts tagged with