if formula not working and showing false result

arif mamun

New Member
Joined
Nov 10, 2019
Messages
1
10000

<tbody>
</tbody>
=IF(A8>0<=100000,25,IF(A8>100000<=500000,50,IF(A8>500000<=50000000,100))) result is showing false . why

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,059
Office Version
365, 2010
Platform
Windows, Mobile
Maybe...
=IF(AND(A8>0,A8<=100000),25,IF(AND(A8>100000,A8<=500000),50,IF(AND(A8>500000,A8<=50000000),100,"THE FIGURE IS ZERO (or below) OR GREATER THAN 50000000")))
Guessing a bit because you have a stray 1000 in your post and you don't state exactly what you want the code to do.
 
Last edited:

mohadin

Active Member
Joined
Mar 22, 2015
Messages
361
Office Version
2013
Platform
Windows
Deleted
 
Last edited:

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
43,541
Office Version
365
Platform
Windows
result is showing false . why
Because the syntax in your formula is wrong. See if this is closer

=IF(AND(A8>0,A8<=100000),25,IF(AND(A8>100000,A8<=500000),50,IF(AND(A8>500000,A8<=50000000),100,">50000000")))

Edit: Oops, actually, I think this is effectively the same as Mark's in post 2
 
Last edited:

Forum statistics

Threads
1,089,657
Messages
5,409,567
Members
403,271
Latest member
Rajeev Muraleedharan

This Week's Hot Topics

Top