Google Sheets- How to express a range of values with nested if loops [on hold]

up vote
-3
down vote

favorite

This is a nested if loop I wrote in google spreadsheets

enter image description here

Whenever I enter a value for B5 between 0 and 1 like 0.5, it says there is "no match".

I think there is something wrong with the last section of the code.
I was wondering if anyone knew how to fix this?

Thank you very much.

asked Nov 18 at 16:27

mjj

New contributor

put on hold as off-topic by 200_success, Graipher, vnp, Jamal♦ Nov 19 at 1:01

This question appears to be off-topic. The users who voted to close gave this specific reason:

"Code not implemented or not working as intended: Code Review is a community where programmers peer-review your working code to address issues such as security, maintainability, performance, and scalability. We require that the code be working correctly, to the best of the author's knowledge, before proceeding with a review." – 200_success, Graipher, vnp, Jamal

If this question can be reworded to fit the rules in the help center, please edit the question.

add a comment |

up vote
-3
down vote

favorite

This is a nested if loop I wrote in google spreadsheets

enter image description here

Whenever I enter a value for B5 between 0 and 1 like 0.5, it says there is "no match".

I think there is something wrong with the last section of the code.
I was wondering if anyone knew how to fix this?

Thank you very much.

asked Nov 18 at 16:27

mjj

New contributor

put on hold as off-topic by 200_success, Graipher, vnp, Jamal♦ Nov 19 at 1:01

This question appears to be off-topic. The users who voted to close gave this specific reason:

"Code not implemented or not working as intended: Code Review is a community where programmers peer-review your working code to address issues such as security, maintainability, performance, and scalability. We require that the code be working correctly, to the best of the author's knowledge, before proceeding with a review." – 200_success, Graipher, vnp, Jamal

If this question can be reworded to fit the rules in the help center, please edit the question.

add a comment |

up vote
-3
down vote

favorite

This is a nested if loop I wrote in google spreadsheets

enter image description here

Whenever I enter a value for B5 between 0 and 1 like 0.5, it says there is "no match".

I think there is something wrong with the last section of the code.
I was wondering if anyone knew how to fix this?

Thank you very much.

asked Nov 18 at 16:27

mjj

New contributor

This is a nested if loop I wrote in google spreadsheets

enter image description here

Whenever I enter a value for B5 between 0 and 1 like 0.5, it says there is "no match".

I think there is something wrong with the last section of the code.
I was wondering if anyone knew how to fix this?

Thank you very much.

google-sheets

asked Nov 18 at 16:27

mjj

New contributor

asked Nov 18 at 16:27

mjj

New contributor

asked Nov 18 at 16:27

mjj

New contributor

asked Nov 18 at 16:27

mjj

asked Nov 18 at 16:27

mjj

New contributor

mjj is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

put on hold as off-topic by 200_success, Graipher, vnp, Jamal♦ Nov 19 at 1:01

This question appears to be off-topic. The users who voted to close gave this specific reason:

"Code not implemented or not working as intended: Code Review is a community where programmers peer-review your working code to address issues such as security, maintainability, performance, and scalability. We require that the code be working correctly, to the best of the author's knowledge, before proceeding with a review." – 200_success, Graipher, vnp, Jamal

If this question can be reworded to fit the rules in the help center, please edit the question.

put on hold as off-topic by 200_success, Graipher, vnp, Jamal♦ Nov 19 at 1:01

This question appears to be off-topic. The users who voted to close gave this specific reason:

"Code not implemented or not working as intended: Code Review is a community where programmers peer-review your working code to address issues such as security, maintainability, performance, and scalability. We require that the code be working correctly, to the best of the author's knowledge, before proceeding with a review." – 200_success, Graipher, vnp, Jamal

If this question can be reworded to fit the rules in the help center, please edit the question.

add a comment |

active

oldest

votes

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Cfrtjryk