I know this shouldn't be this difficult, but what I am looking to do is
I want a total in A5, based on a running total in A1 through A4.
For example, if A4 is blank then input A5=A3, if A3 is blank than A5=A2, if A2 is blank then A5=A1. If there was a value in A4 than A5=A4.
Thought:
IF(A4>"0",A4,A3),IF(A3>"0",A3,A2),IF(A2>"0",A2,A1),IF(A1>"0","A1",0))