IF Function- Adding a formula inside a quote

[Katie]

Hello,

I have this formula:
=IF(C36<(C4*0.1),"First payment must be at least 10%"," ")

I would like it to read:
=IF(C36<(C4*0.1),"First payment must be at least {result
of cell F10}"," "), so that if F10 equals $2000, the
result would read: "First payment must be at least $2000".

But when I try to do that, the result of the formula
displays as:
"First payment must be at least F10".

Any suggestions???

Kate

 

[Andy B]

Katie

Try this:

=IF(C36<(C4*0.1),"First payment must be at least £"&F10," ")

Andy

 

[Frank Kabel]

Hi Katie

try
=IF(C36<(C4*0.1),"First payment must be at least " & F10," ")

HTH
Frank

 

[Katie]

This formula worked! The only problem is, it displays the
£ symbol in the result. I tried taking it out of the
quotes and it produced and error. Any thoughts??

 

[Andy B]

Katie.

Sorry! I'm in the UK so I put it in there!! Try this:

=IF(C36<(C4*0.1),"First payment must be at least "&F10," ")

Andy.

This formula worked! The only problem is, it displays the
£ symbol in the result. I tried taking it out of the
quotes and it produced and error. Any thoughts??

 

[Kate]

It worked! Thank you.

-----Original Message-----
Katie.

Sorry! I'm in the UK so I put it in there!! Try this:

=IF(C36<(C4*0.1),"First payment must be at least "&F10," ")

Andy.

This formula worked! The only problem is, it displays the
£ symbol in the result. I tried taking it out of the
quotes and it produced and error. Any thoughts??




.

 

[Andy B]

Kate

Thanks for saying Thanks! It's nice to get a 'thank-you' every now and
then!!

Andy.

It worked! Thank you.