Good morning. I am a novice when it comes to excel and need help with a formula similar to the following:
=(H3+J3)-L3 >
Would anyone have a minute to tell me what am I doing wrong?
Thanks
Good morning. I am a novice when it comes to excel and need help with a formula similar to the following:
=(H3+J3)-L3 >
Would anyone have a minute to tell me what am I doing wrong?
Thanks
Welcome to the forum.
All we're missing is what you're trying to do.
Entia non sunt multiplicanda sine necessitate
thank you - lovin the flag by way (former Texas girl myself)
H3=costs to date
J3=accrued P/L
L3=billings
what I need is the number greater than billings in one column and less than billings in another column.
Still not sure what you mean.
Maybe =MAX(H3+J3-L3, 0) in one column and =MIN(H3+J3-L3, 0) in the other.
I was afraid I wouldn't be able to explain it well enough. I'll try it and be back. Thanks for quick response - this forum is great!
So sorry - I got caught up with other things and just now am getting back to this.
I think we're close - it's bringing up *NAME? where the difference should be. I'll keep trying but so appreciate the help and will more than likely be back if not for this issue, another.
Thanks again!
It worked - thank you so very much!
Good job.
Would you please mark the thread as Solved? (See How To in menu bar.)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks