Hello,
I'm new to the forum. I'm trying to get a nested if then statement where one of the conditions includes a value that accounts for a range greater than 1 but less than 80. What I have so far (the and statement doesn't work, but shows what I need):
=IF((F10:F23)=0,0),IF((F10:F23)>=80,SUM(I10:I23)),IF((F10:F23)>1and<80,SUM(F10:F23)+SUM(G10:G23)+SUM(H10:H23)+SUM(I10:I23)-80)
Any help would be appreciated.
Bookmarks