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 dont understand why this formula keeps producing the ?name error message
=IFS(C3="ISBLANK",0,C3=“YES”,100-D3,C3="PENDING",50-D3,C3="NO",50-D3)
C3 is a cell that can have either value of BLANK, YES, NO, PENDING
D3 is a cell with any positive numerical value up to 100.
I want F3 (which is where this formula is located) to say "If C3 is empty, then read 0, if the C3 reads YES then read the Value of 100 - D3, if C3 reads PENDING then read the value of 50 - D3, and if C3 reads NO then read the value of 50 - D3"
Everything I've read says this is correct. But its not. Please help. Here's what the spread sheet looks like:
| RENTAL PROPERTY PAYMENTS REGISTRY | |||||
|---|---|---|---|---|---|
| Photographed Property Address | Date Final Edits Delivered | LEASED (YES/NO/PENDING) | Total Payments Made | Total Pending Lease | Total owed |
| 2/1/2018 | PENDING | $ <br>- | $ <br>50.00 | #NAME? | |
| 2/1/2018 | PENDING | $ <br>- | $ <br>50.00 | $ <br>50.00 |
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 Adam, try this formula:
=IF(ISBLANK(C3), 0,IF(C3="YES", 100-D3, IF(C3="PENDING", 50-D3, IF(C3="NO", 50-D3,""))))
Glad to help, if you have any more questions, please contact us here at MS Community!
You're the best!! Thank you