Removing false in excel [Solved/Closed]

Question

Removing false in excel [Solved/Closed]

Report

umer007

Posts: 3
Registration date: Sunday February 1, 2015
Status: Member
Last seen: February 6, 2015

- Feb 1, 2015 at 06:23 AM
umer007

Posts: 3
Registration date: Sunday February 1, 2015
Status: Member
Last seen: February 6, 2015

- Feb 2, 2015 at 05:42 AM

=IF(D5>=150000,D5*21/100,IF(D5>=100000,D5*15/100,IF(D5>=70000,D5*21/100,IF(D5>=50000,D5*7/1000))))

What,s wrong in this formula Please Help!

How to get rid of false in excel
How to remove false in excel - Best answers
Remove false in excel - Best answers
Removing " false" value in "IF" ✓ - Forum - Office Software
Removing False Value ✓ - Forum - Excel
Need help to remove FALSE from cell ✓ - Forum - Office Software
Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Forum - Excel
Get rid of false in excel - Forum - Excel

2 replies

Answer 2 / 2

umer007

Posts: 3
Registration date: Sunday February 1, 2015
Status: Member
Last seen: February 6, 2015

Feb 2, 2015 at 05:42 AM

ThanX for your help

Ask a question

RayH · Accepted Answer · 2015-02-01T19:56:08-0500

Answer 1 / 2

RayH

Posts: 122
Registration date: Tuesday August 31, 2010
Status: Contributor
Last seen: June 20, 2016

24
Feb 1, 2015 at 07:56 PM

You are missing what happens if the evaluations are not met.

The , "" is required to do that.

=IF(D5>=150000,D5*21/100,IF(D5>=100000,D5*15/100,IF(D5>=70000,D5*21/100,IF(D5>=50000,D5*7/1000,""))))

Removing false in excel [Solved/Closed]

2 replies

Your reply

Subscribe To Our Newsletter!