[Solved] Why doesn't this formula work?

[sigsky]

It sure looks as though it should. Correct answer should be .308.

I saw a post complaining about only attaching images so I have also attached the file.
err 504 indicates a parameter is invalid, i.e. not numeric, but I don't see it.

[Lupp]

Code: Select all

{AB85} =IF(AB80>0;ROUND(AB80/(AA80-AE80-AK80-AO80-AN80-AM80));3;"")

You cannot have two alternatives in an IF() call. The value 3 should be assumed to be the number of decimal places for ROUND() to work with. It must be on the appropriate parameter place therefor.

Code: Select all

=IF(AB80>0;ROUND(AB80/(AA80-AE80-AK80-AO80-AN80-AM80);3);"")

[sigsky]

Thanks, I should have been able to figure that out, but I played with it an hour this morning.