This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am trying to multiply =(True)*1 and I get the following Error: #VALUE!. The cell that I am multiplying the 'True' from is from the following formula: =IF(D14="Pass","True","False"). What can I do to correct this?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Hi there
You may also try the formulas
=(D14="Pass")*1 Or =--(D14="Pass")
I hope this also helps you
Regards
Jeovany
Answer accepted by question author
Hello,
Please try this formula: =IF(D14="Pass",TRUE,FALSE)*1
But, can I know why you need to multiple the formula with 1? If you are looking for output "1" if the condition is true and "0" if the condition is false, please use this formula: =IF(D14="Pass",1,0)
Best Regards,
Chitrahaas