Hi Laura
I'd try the following formula
=IF(A5=MIN('sheet1:sheet5'!A24:A30),45000,MIN('sh eet1:sheet5'!A24:A30)
)

if I understood your logic correctly


--
Regards
Frank Kabel
Frankfurt, Germany


Laura wrote:
I have a whopper of an If statement and prior to
completion, I received the error that the formula is too
long. Is there any way around this?

Sample before I was cut off:

=MIN(IF(A5=Sheet1!$A$24,45000,Sheet1!$A$24),IF(A5 =Sheet2!
$A$24,45000,Sheet2!$A$24),IF(A5=Sheet3!$A$24,4500 0,Sheet3!
$A$24),IF(A5=Sheet4!$A$24,45000,Sheet4!$A$24),IF
(A5=Sheet5!$A$24,45000,Sheet5!$A$24),IF(A5=Sheet 1!
$A$25,45000,Sheet1!$A$25),IF(A5=Sheet2!$A$25,4500 0,Sheet2!
$A$25),IF(A5=Sheet3!$A$25,45000,Sheet3!$A$25),IF
(A5=Sheet4!$A$25,45000,Sheet4!$A$25),IF(A5=Sheet 5!
$A$25,45000,Sheet5!$A$25),IF(A5=Sheet1!$A$26,4500 0,Sheet1!
$A$26),IF(A5=Sheet2!$A$26,45000,Sheet2!$A$26),IF
(A5=Sheet3!$A$26,45000,Sheet3!$A$26),IF(A5=Sheet 4!
$A$26,45000,Sheet4!$A$26),IF(A5=Sheet5!$A$26,4500 0,Sheet5!
$A$26),IF(A5=Sheet1!$A$27,45000,Sheet1!$A$27),IF
(A5=Sheet2!$A$27,45000,Sheet2!$A$27),IF(A5=Sheet 3!
$A$27,45000,Sheet3!$A$27),IF(A5=Sheet4!$A$27,4500 0,Sheet4!
$A$27),IF(A5=Sheet5!$A$27,45000,Sheet5!$A$27))


Any insights are most appreciated.