Simple Formula error

[mayday1]

I've been staring at this too long and can't figure it out. When C2 is greater than 0, it gives me the value of E3*F3 plus E50*F50 (always above 0 if C2 is above 0). Why doesn't this formula divide by the value in cell C2? That value should be divided by C2, shouldn't it?

=IF(C2>0,(('[UDR 2019.xlsx]04-01'!$E$3*'[UDR 2019.xlsx]04-01'!$F$3)+('[UDR 2019.xlsx]04-01'!$E$50*'[UDR 2019.xlsx]04-01'!$F$50)/C2),"")

When C2 is blank, the formula returns a blank, as it should.

 

[Fluff]

You've got the /C2 in the wrong place, it should be
=IF(C2>0,(('[UDR 2019.xlsx]04-01'!$E$3*'[UDR 2019.xlsx]04-01'!$F$3)+('[UDR 2019.xlsx]04-01'!$E$50*'[UDR 2019.xlsx]04-01'!$F$50))/C2,"")

 

[mayday1]

Duh. Thank you, Fluff!

 

[Fluff]

You're welcome & thanks for the feedback