IF statements help

[jon2249]

For CELL B6 I have

=IF(B5="EHDW",B6='Rates by Demand'!B4,IF(B5="EHDE",B6=X,IF(B5="HDW",B6='Rates by Demand'!C4,IF(B5="HDE",B6=X,B6 = FIX ME))))

I have a bunch of parameters
EHDW EHDE HDW HDE HSDW HSDE LSDW LSDE etc...
If cell B5="EHDW" I want B6 to pull data from Rates By Demand Tab Cell B4. ($629)

Instead it is pulling a $0.00. Any Idea why this is happening?

 

[Smitty]

Welcome to the Board!

Just reference the sheet range directly:

=IF(B5="EHDW",'Rates by Demand!B4,IF(B5="EHDE","X",IF(B5="HDW",'Rates by Demand'!C4,IF(B5="HDE","X","FIX ME"))))

Although for a bunch of different parameters like that I'd use a Lookup table instead of a bunch of nested IF's, which can get hard to maintain in a hurry.

HTH,