Forum Discussion
Multiple IF statements, I think
MattP817 I think i can do 1 better. If you unmerge the cells (at least in column G) then this formula can be pasted on the entire column (paste formula only to maintain other formatting):
=IFS(A6="Time","Units/Hr.",B6="PO#","Unit Rate",A6="","",NOT((A6<=2)*(A6>=0)),"",(E5>" ")*(E6=""),LET(a,XLOOKUP(C6,$C$1:$C5,$F$1:F5,0,0,-1),IF(F6<a,F6,F6-a)),F6<F5,F6,TRUE,(F6-F5))In the attached I unmerged cells in rows 31-34 and tested it there and seems to work well. Basically instead of copy and paste each section you will be able to copy and paste on the entire column (paste formula only).
MattP817 I think i can do 1 better. If you unmerge the cells (at least in column G) then this formula can be pasted on the entire column (paste formula only to maintain other formatting):
=IFS(A6="Time","Units/Hr.",B6="PO#","Unit Rate",A6="","",NOT((A6<=2)*(A6>=0)),"",(E5>" ")*(E6=""),LET(a,XLOOKUP(C6,$C$1:$C5,$F$1:F5,0,0,-1),IF(F6<a,F6,F6-a)),F6<F5,F6,TRUE,(F6-F5))In the attached I unmerged cells in rows 31-34 and tested it there and seems to work well. Basically instead of copy and paste each section you will be able to copy and paste on the entire column (paste formula only).
