Hi guys!
I have a formula with nested if statements and the main portion of it works .
I also wanted to have it return 100 if the portion C53/C57*100 returned a value >100, but can't seem to figure it out .
This is the forumla:
=IF(ISNUMBER(C57),C53/C57*100,IF(AND(C54>=200,C53<75),0,IF(AND(C54<200,C53>0),0,IF(AND(C54>0,C53<75),0,IF(AND(C54>300,C53>=75),100)))))
Any help would be great!!!
Thanks!
Bookmarks