Assuming cols A and B, from row1 down contain the formulae:
=randbetween(40,50)
=randbetween(35,45)

You could put this in C1, copied down,
to track the results of the randomization in cols A and B:
=IF(AND(SUM(A1:B1)=83,SUM(A1:B1)<=88),SUM(A1:B1), "")

Rows not evaluating to blanks ("") in col C
would then provide the result lines that you're looking for
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"ramana" wrote in message
oups.com...
Hi every body,

I have three columns A,B&C In the column A Iwill generate random
numbers between 40&50, In the Column B I will generate random numbers
between 35&45, The column C is the sum of Column A&B(i.e. C=A+B) but I
the sum should be between 83&88. I need acondition such that the random
numbers generated in Column A&B Should satisfy the Column C(A+B)
condition sdatisfying the A&B columns condition.

Can anybody help me out regarding this issue.

Thanks and Regards

Ramana