if statement = false

**vvishalb** · 09-03-2022, 04:24 AM

if statement = false What is the problem please tell me the solution. The same question was asked on another forum but no answer.

https://www.mrexcel.com/board/thread...rmula.1214972/

It would be great if someone could help me here
If statment = false.jpeg

**Glenn Kennedy** · 09-03-2022, 04:35 AM

"Open Price is below L4" does not equal "Open Price below L4". Make them the same. All those ANDS are redundant, too.

=IF($F$8=K4,"A",IF($F$8=K20,"B",IF($F$8=K36,"C",IF($F$8=K52,"D",IF($F$8=K68,"E","F")))))

**vvishalb** · 09-03-2022, 05:08 AM

Wow, you are so goooood,

Thank you very very much

**vvishalb** · 09-03-2022, 05:23 AM

Thank you very much once again. you made my day

**Glenn Kennedy** · 09-03-2022, 05:24 AM

Hahaha. You're welcome!

if statement = false

LinkBack

Thread Tools

Rate This Thread

Display

if statement = false

Re: if statement = false

Re: if statement = false

Re: if statement = false

Re: if statement = false

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to get rid of a False Statement

If statement resolves as true when statement is false

[SOLVED] IF statement with IF Statement as logical test, and output if false

[SOLVED] How can IIF Statement bring false statement?

If statement, answer is false, hide false.

If statement with a range and true/false statement

If statement that does nothing when false

Bookmarks

Bookmarks

Posting Permissions