Nested IF Function not working! HELP!

[awd_awd]

I have a sheet that can use three different RTD sources.

I have the following IS statement that returns the correct data given what RTD feed is being used.

=IF($B$98="BLOOMBERG";$C$134),IF($B$98="Reuters";$C$135; 'MV Data'!C4))*100

However, it does not work...

Can anyone offer any help on this?

Thanks in advanced.

 

[wwbwb]

Try this?
=IF($B$98="BLOOMBERG",$C$134,IF($B$98="Reuters",$C$135,'MV Data'!C4))*100

 

[Came to drop Brahms]

I have a sheet that can use three different RTD sources.

I have the following IS statement that returns the correct data given what RTD feed is being used.

=IF($B$98="BLOOMBERG";$C$134),IF($B$98="Reuters";$C$135; 'MV Data'!C4))*100

However, it does not work...

Can anyone offer any help on this?

Thanks in advanced.

Get rid of those semi-colons and replace them with commas. You have your parenthesis in funky spots as well, so double check that after you fix the semi-colon issue.

 

[awd_awd]

Thanks guys, but now it does not split the IF statements, so its still not working....

 

[awd_awd]

Get rid of those semi-colons and replace them with commas. You have your parenthesis in funky spots as well, so double check that after you fix the semi-colon issue.

=IF($B$98="BLOOMBERG",$C$134, IF($B$98="Reuters",$C$135,'MV Data'!C4))*100

can you guide me as to where the parenthesis should be ?

thanks in advanced.

 

[wwbwb]

=IF($B$98="BLOOMBERG",$C$134, IF($B$98="Reuters",$C$135,'MV Data'!C4))*100

can you guide me as to where the parenthesis should be ?

thanks in advanced.

Parenthesis are fine in that version.

 

[awd_awd]

Parenthesis are fine in that version.

Guys,

Still having trouble with this.

Below is a link to a mock up of the sheet.

If one you could have a look i would be very grateful

http://we.tl/tBEe42bVlI

Thanks in advanced.

 

[StefanVL]

Guys,

Still having trouble with this.

Below is a link to a mock up of the sheet.

If one you could have a look i would be very grateful

http://we.tl/tBEe42bVlI

Thanks in advanced.

According to this sheet:

=IF(C12="Bloomberg";C18;IF(C12="Reuters";C19;IF(C12="Global View";C20)))

 

[awd_awd]

According to this sheet:

=IF(C12="Bloomberg";C18;IF(C12="Reuters";C19;IF(C12="Global View";C20)))

That's done it! thanks for your help!