Thread
:
Formula help
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Teethless mama
external usenet poster
Posts: 3,718
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)?
Reply With Quote
Teethless mama
View Public Profile
Find all posts by Teethless mama