Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Nested "IF" Statement
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!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested "IF" Statement
lajohn63 wrote:
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"IF" Statement Problem | Excel Worksheet Functions | |||
Nested IF statement with VLOOKUP | Excel Discussion (Misc queries) | |||
:confused: Nested if then else statement | Excel Worksheet Functions | |||
Problem with nested IF_OR statement | Excel Worksheet Functions | |||
7+ nested if statement? | Excel Worksheet Functions |