IF statement maybe?

[dskeane]

Looking for some assistance handling an if statement.

Everything in the highlighted area works however returns a NaN if Labor total has $0.00 in the field. 

When adding the extra if statement "not highlighted" i keep getting an error. 

example, calculatedlabor total / est sw = value "this part works" only when the calulatedlabortotal is a $0.00 then it does not work, so I add another if condition to try resolve this issue. (hope this makes sense)

Appreciate any feedback. 

[Ashish_Mathur]

Hi,

Why are you using an AND function inside the IF function?  Also, is the calculatedlabourtotal column a text column.  If it is, then write "0", else just 0.

[dskeane]

AND was added to try somethign different. 

I guess to keep this simple is there a certain way to handle 0 divided by  0 using an IF Statment to return a value of 0?

Right now I am getting NaN as the result.

[mattbrice]

---

wrote:

AND was added to try somethign different. 

I guess to keep this simple is there a certain way to handle 0 divided by  0 using an IF Statment to return a value of 0?

Right now I am getting NaN as the result.

---

use DIVIDE function. 

[Greg_Deckler]

Nope, I don't get it. Sample data would be great to recreate. 

It looks like you are using AND incorrectly though.