IF Function- Adding a formula inside a quote

  • Thread starter Thread starter Katie
  • Start date Start date
K

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
 
Hi Katie

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

HTH
Frank
 
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??
 
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??
 
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??




.
Click to expand...
 
Kate

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

Andy.

It worked! Thank you.
 
Back
Top