Adding another IF to formula

=IF(OR(Q118={"$","€"}),VLOOKUP(E118,[RefHidden_120112.xlsm]Ref!$BY$5:$CB$60,MATCH(Q118,[RefHidden_120112.xlsm]Ref!$BY$3:$CB$3,0)),"1.00")

I want to adapt this formula for it to return "--" IF Q118="". I am not sure of the syntax to add the extra IF. Thanks.

Dan

Thanks. That's where I got confused. I didn't realise that the originally formula was just an IF statement with other functions inside. I have laid out you suggestion like so:

=IF(Q118="", "--",
IF(OR(Q118={"$","€"}),VLOOKUP(E118,[RefHidden_120112.xlsm]Ref!$BY$5:$CB$60,MATCH(Q118,[RefHidden_120112.xlsm]Ref!$BY$3:$CB$3,0)),
"1.00"))

so I can see make sense of it. Will it increase the size of my excel files and make my spreadsheets slow if I enter formulas like this instead of one long string? Thanks again.