Hi guys,
I've been struggling to find a way of searching for the Max in a row of cells and then add another cell's quantity to it.
I assumed I'd need a if statement (first) combined with a max statement (second), but there doesn't seem to be much advice out there on this.
So far I've tried if(max($A$1:$D$1),A1+$G$1,A1+0)
This just seems to add the G1's cell contents to the entire range.
Any advice would be very useful.
Cheers
I've been struggling to find a way of searching for the Max in a row of cells and then add another cell's quantity to it.
I assumed I'd need a if statement (first) combined with a max statement (second), but there doesn't seem to be much advice out there on this.
So far I've tried if(max($A$1:$D$1),A1+$G$1,A1+0)
This just seems to add the G1's cell contents to the entire range.
Any advice would be very useful.
Cheers
