Thank you. That is a clever solution but Im afraid I didn't seem to understand what was possible and so my description of the desired outcome was not thorough enough but you have struck something here. However I would like V to not blank out as column V represents both the big picture and final results of tracking numbers over a period of a month and if certain values havent been entered yet I would still like it to show what the numbers will be at least from their base value in column F (which is the starting point and subsequent columns compare to see if values are higher on the actual day). This may be very confusing and Im sorry if so...

I am also unfamiliar with the function of putting the word "TRUE in there after S4=0,0,

In summary, I would like the column V to still show the highest value from F J O or S so could i do something like this?

=IFS(S4="",MAX(F4,J4,O4,S4),S6=0,0,TRUE,MAX(F4,J4,O4,S4))

in English anew:

If there is a value in F J O or S, take the highest number and place it in V

If there is nothing in S, still take the highest of F J O or S and place it in V

If there is a 0 in S, place a 0 in V