formula help (If statment)

[shehla.uhp1]

Hi,

I am looking for formula for the following condition.

I have a table that has columns:

Type	Gross	Detail.Debit	Detail.Credit
CR	17250		17250
CP	3150.8	3150.8
CP	500	500
DI	500		500
CI	500	500

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

I am looking for any if functions so that If type is CR the Detail Credit column pick the gross value and detail debit column left blank.

For type CR,CI the gross should be shifted to detail credit column.
For type CP,DI the gross should be shifted to detail debit column.

Thanks.

 

[Andrew Poulsom]

In C2:

=IF(OR(A2="CP",A2="DI"),B2,"")

and in D2:

=IF(OR(A2="CR",A2="CI"),B2,"")

Copy the formulas down.

 

[anandvarma]

in cell c2 try this
=IF(OR(INDIRECT("a"&ROW())="CP",INDIRECT("a"&ROW())="DI"),INDIRECT("b"&ROW()),"") and drag it down

in cell D2 try this
=IF(OR(INDIRECT("a"&ROW())="CR",INDIRECT("a"&ROW())="CI"),INDIRECT("b"&ROW()),"") and drag it down