Nested if function

[maniknandi]

Attached please find.

Thanks in advance.

 

[Pavan Kumar Sistla]

Dear Maniknandi,

Attached is the file for your reference.

Thank You and Regards,
Pavan.

 

[Naresh Yadav]

Hi,

try this in F4

=IF(OR(E7="DPR Approved",E7="DPR Under Preparation",E7="Tender Issued"),C7,D7)

 

[bosco_yip]

Or……

In F4, copied down :

=IF(LEFT(E4)="W",D4,C4)

Regards

 

[maniknandi]

1st row extracting WO Cost instead of Tender Cost.

 

[maniknandi]

Hi,

try this in F4

=IF(OR(E7="DPR Approved",E7="DPR Under Preparation",E7="Tender Issued"),C7,D7)

Its working fine sir, Thanks....

 

[rahulshewale1]

Hii,

In F4, copied down :

=IF(OR(E4="DPR Approved",E4="DPR Under Preparation",E4="Tender Issued"),C4,IF(OR(E4="Work Completed",E4="Work Order Issued"),D4,""))


Regard
Rahul shewale

 

[Naresh Yadav]

or..

=IF(OR(E4={"DPR Approved","DPR Under Preparation","Tender Issued"}),C4,D4)

regards
Naresh