Will it make any difference if I am doing this within a table
for example
=IF(Table4[[#This Row],['# of 1''s]]>Table4[[#This Row],[Amt. Audit]],over 100%,Table4[[#This Row],['# of 1''s]]/Table4[[#This Row],[Amt. Audit]])
Or
=IF(Table4[[#This Row],['# of 1''s]]>Table4[[#This Row],[Amt. Audit]],1,Table4[[#This Row],['# of 1''s]]/Table4[[#This Row],[Amt. Audit]])
Bookmarks