Nested "IF" Statement

[lajohn63]

I'm trying to do nested IF's, when I run each if statement seperatel
they work fine, but when I merge them into one line of code they giv
me #Value error. Any help would be appreciated!

Here's the 3 specific lines:

=IF('Requestor Information'!E28"",'Requestor Information'!E28)

=IF(AND(C50,'Requestor Information'!G35="Yes"),SUM('Requesto
Information'!E28+7+3))

=IF(AND(C50,(OR('Requestor Information'!G35="No",'Requesto
Information'!G35=""))),SUM('Requestor Information'!E28+7+1))


Putting them together --
=IF('Requestor Information'!E28"",'Requesto
Information'!E28),IF(AND(C50,'Requesto
Information'!G35="Yes"),SUM('Requesto
Information'!E28+7+3)),IF(AND(C50,(OR('Requesto
Information'!G35="No",'Requestor Information'!G35=""))),SUM('Requesto
Information'!E28+7+1))

I also want to add another bit of code that says if any of the number
returned are 10 then the cell will = 10... I haven't even looked a
that yet until I can get the other problem resolved!!

 

[Franz Verga]

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(C50,'Requestor Information'!G35="Yes"),SUM('Requestor
Information'!E28+7+3))

=IF(AND(C50,(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(C50,'Requestor
Information'!G35="Yes"),SUM('Requestor
Information'!E28+7+3)),IF(AND(C50,(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!!!

Maybe it could be simpler if you could describe what are you trying to do...

--
Thanks in advance for your feedback.

Ciao

Franz Verga from Italy