If Statement in word

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 ?

Answer
Answer

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

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy

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.

Answer
Answer

Or you could forego the IF test and, instead, use:

{=(D14>8000)*D14*.02 \# "0;;"}

Cheers
Paul Edstein
(Fmr MS MVP - Word)

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.

 
 

Question Info


Last updated October 5, 2021 Views 100 Applies to: