Help with formula based on value of a third cell

[RodneyW]

I need a formula for cell AH4 that I can drag down.

In cell AH4, I need a formula that will calculate this:

If I4=Y, then G4*$AH$1 if I4=N then G4*$AI$1

Thanks in advance

 

[ravishankar]

try
=if($I4=$B$1,$G4*$AH$1,if($I4=$C$1,$G4*$AH$1,""))
store the values of Y and N in B1 and C1 cells

 

[Fluff]

Like
=IF(I4="Y",G4*$AH$1,G4*$AI$1)

 

[RodneyW]

Thank you both for your help. The formula need evolved after I got your posts and we figured it out. Thanks again

 

[Fluff]

Glad it's sorted & thanks for the feedback