Multiple IF values for cell

[bumfart66]

=IF(C9="Read Only","n/a",IF(C9="Quarter 4",SUM(D3,0)))

C9 can be Read Only and Quarter 1-4, This checks for Read Only and Quarter 4, how do i get it to check for Quarter 3 2 and 1

 

[oldbrewer]

if C9= "red" you will get an error message

but to add the other quarters

=IF(C9="Read Only","n/a",IF(C9="Quarter 4",SUM(D3,0),if(c9="Quarter 3",sum(),ifc9="Quarter 2",sum(),sum())),"C9 is none of these")

 

[bumfart66]

if C9= "red" you will get an error message

but to add the other quarters

=IF(C9="Read Only","n/a",IF(C9="Quarter 4",SUM(D3,0),if(c9="Quarter 3",sum(),ifc9="Quarter 2",sum(),sum())),"C9 is none of these")

Thanks , not pretty but used this

=IF(C10="Read Only","n/a",IF(C10="Quarter 4",SUM(D5,0),IF(C10="Quarter 3",SUM(D5,0),IF(C10="Quarter 2",SUM(D5,0),IF(C10="Quarter 1",SUM(D5,0))))))

 

[FDibbins]

1. you don't need to use SUM to refer to 1 cell, just reference that cell.
2. If you are looking for any 1 of 4 Qtr's, then why even test for that? You can only have 1, 2, 3 or 4 Qtr?
3. try this....
=IF(C10="Read Only","n/a",D5)

 

[bumfart66]

1. you don't need to use SUM to refer to 1 cell, just reference that cell.
2. If you are looking for any 1 of 4 Qtr's, then why even test for that? You can only have 1, 2, 3 or 4 Qtr?
3. try this....
=IF(C10="Read Only","n/a",D5)

Thanks