Formula help
Can anyone help with this:
If the sum of C1:Z1 = 100, How can I get a value for A1 that never exceeds 10 AND B1 to equal the difference of C1:Z1 and A1 (B1=90 in this example)? |
Formula help
=IF(A1<=10,SUM(C1:Z1)-A1,"")
"rldjda" wrote: Can anyone help with this: If the sum of C1:Z1 = 100, How can I get a value for A1 that never exceeds 10 AND B1 to equal the difference of C1:Z1 and A1 (B1=90 in this example)? |
Formula help
Please don't multipost. Cross-post if you need to.
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html -- David Biddulph "rldjda" wrote in message ... Can anyone help with this: If the sum of C1:Z1 = 100, How can I get a value for A1 that never exceeds 10 AND B1 to equal the difference of C1:Z1 and A1 (B1=90 in this example)? |
All times are GMT +1. The time now is 08:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com