shorten nested if

=IF(WEEKNUM(TODAY(),16)=14,IF(R6>1,1,R6),IF(WEEKNUM(TODAY(),16)=15,IF(R6>2,2,R6),IF(WEEKNUM(TODAY(),16)=16,IF(R6>3,3,R6),IF(WEEKNUM(TODAY(),16)>16,IF(R6>4,4,R6)))))/LOOKUP(WEEKNUM(TODAY(),16), {14,15,16,17;1,2,3,4})

By: eds

Leave a Reply

Your email address will not be published. Required fields are marked *