I wont to put an if statement in a word doc but it keeps coming up syntax error
my cell ref is D14 and this is what I put my formula in as
=IF(D14>8000,D14*2%,"") what am I doing wrong ?
I wont to put an if statement in a word doc but it keeps coming up syntax error
my cell ref is D14 and this is what I put my formula in as
=IF(D14>8000,D14*2%,"") what am I doing wrong ?
Reported content has been submitted
Assuming that you want the result to be 2% of the amount in D14 if it is greater that 8000, you need to use
{ IF { =D14 } > 8000 { = D4*0.02 } "" }
You must use CTRL+F9 to insert each pair of field delimiters
Reported content has been submitted
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Or you could forego the IF test and, instead, use:
{=(D14>8000)*D14*.02 \# "0;;"}
Reported content has been submitted
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.