Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Thu, 16 Jan 2025 20:03:57 +0000

How to Post a Message for Support

Post From: Problem formula getting ARGS! sporadic

[2017-11-15 23:34:52]
[Go To First Post]
GiantAvocado - Posts: 67
Anyone see a problem with this formula? I am getting the ARGS! sporadically down the column & creates ARGS! on dependent cells?
This does some math on some constants in the $ cells, I must be missing something simple here, but am brain numb now.

=IF(AH3>0, IF(AH3<$Cq$3,3, IF(AH3<$Cp$3,(AH3-$Cp$3)/$CS$3, IF(AH3<$Co$3,(AH3-$Co$3)/$Cr$3, IF(AH3>=$Co$3,AH3/$Co$3)))),0)