keggerz Posted October 21, 2008 Share Posted October 21, 2008 Ok I hit google and couldn't figure out how to do this as ONE formula. *Note X & Z are not columns but the answers L1-J1=X X/2=Z J1+Z Example: L1=80 J1=20 80-20=60 60/2=30 20+30=50 TIA Quote Link to comment Share on other sites More sharing options...
westvirginia Posted October 21, 2008 Share Posted October 21, 2008 (edited) =(((L1-J1)/2)+J1) I didn't test the above but I would think it would work. ETA: I just tested and that works Edited October 21, 2008 by westvirginia Quote Link to comment Share on other sites More sharing options...
keggerz Posted October 21, 2008 Author Share Posted October 21, 2008 =(((L1-J1)/2)+J1) I didn't test the above but I would think it would work. ETA: I just tested and that works thanks it worked great Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.