"IF" Statement Problem
How about:
=IF('Requestor Information'!E28<"",'Requestor Information'!E28,0)+IF(C5<0,IF('Requestor
Information'!G35="Yes",10,IF(OR('Requestor Information'!G35="No",'Requestor
Information'!G35=""),8,0)))
But it is far better to put your problem into words....
HTH,
Bernie
MS Excel MVP
"lajohn63" wrote in message
...
I'm trying to do nested IF's, when I run each if statement seperately
they work fine, but when I merge them into one line of code they give
me #Value error. Any help would be appreciated!
Here's the 3 specific lines:
=IF('Requestor Information'!E28<"",'Requestor Information'!E28)
=IF(AND(C5<0,'Requestor Information'!G35="Yes"),SUM('Requestor
Information'!E28+7+3))
=IF(AND(C5<0,(OR('Requestor Information'!G35="No",'Requestor
Information'!G35=""))),SUM('Requestor Information'!E28+7+1))
Putting them together --
=IF('Requestor Information'!E28<"",'Requestor
Information'!E28),IF(AND(C5<0,'Requestor
Information'!G35="Yes"),SUM('Requestor
Information'!E28+7+3)),IF(AND(C5<0,(OR('Requestor
Information'!G35="No",'Requestor Information'!G35=""))),SUM('Requestor
Information'!E28+7+1))
I also want to add another bit of code that says if any of the numbers
returned are < 10 then the cell will = 10... I haven't even looked at
that yet until I can get the other problem resolved!!!
--
lajohn63
|