To cell K3, need to make a formula that returns value to Total Paid cell.
Either column G3 or J3 should have a value (same row) -> use that value.
Unless G3-/J3-cells has no value, return F3 value =total paid(column K3). And all the rows down.
How to do this?
Last edited by Tsinos; 04-20-2021 at 04:35 AM. Reason: updated header
One way:
=IFERROR(1/(1/SUM(G3,J3)),F3)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Fantastic! Thank you Glenn. I appreciate a lot!
You're welcome & thanks for the feedback!
One more question, which I did not come to think about in advance.
Either Company A OR Company B can pay the invoice. Can there be a "heads-up" for the user if there is a value both on G3 and J3? that should not be possible.
Yes... maybe this:
=IF(SUM(G3,J3)>MAX(G3,J3),"Alert",IFERROR(1/(1/SUM(G3,J3)),F3))
Works like a Dream! Thanks Glenn. Have a great day !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks