Hi all,
I have been pulling my hair out for the last few hours reworking this nested IF function. I have different values in A and b/c the numbers in front can change from two to three digits I have to use a LEFT/LEN function to remove characters from the right. My embedded IF function first asks if A4 is true then display 0. The second IF asks if PERORDER is in a cell then remove the last 8 characters to display the 35 (A5). Finally, if false then remove the last 6 characters to show 3 (A3).
The function appears to be breaking down on the final rule "the false statement". Thank everyone in advance for reading and replying.
Raw Data (3)
<tbody>
</tbody>
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
I have been pulling my hair out for the last few hours reworking this nested IF function. I have different values in A and b/c the numbers in front can change from two to three digits I have to use a LEFT/LEN function to remove characters from the right. My embedded IF function first asks if A4 is true then display 0. The second IF asks if PERORDER is in a cell then remove the last 8 characters to display the 35 (A5). Finally, if false then remove the last 6 characters to show 3 (A3).
The function appears to be breaking down on the final rule "the false statement". Thank everyone in advance for reading and replying.
Raw Data (3)
* | B | P |
1 | Comm | Comm % |
2 | 3 %not | #VALUE! |
3 | 3 %not | #VALUE! |
4 | ST00 | 0 |
5 | 35PERORDER | 35 |
6 | 3 %not | #VALUE! |
<tbody>
</tbody>
Spreadsheet Formulas | ||||||||||||
<tbody> </tbody> |
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4