hide negative value

[annadinesh]

Dear Experts

my all cell contains formula, and whenever I put discount value on upper cell , the below value s are showing in Negative


How to hide negative value


kindly support

Discount	5%​
Extended Warranty (incl. TAX)	Powertrain Warranty*(incl TAX)
3867.99​	-171.15​
4297.39​	2970.01​
4735.83​	3290.97​
5156.19​	-171.15​
6202.57​	-171.15​
7296.41​	5162.45​
8016.22​	-171.15​
8752.98​	6226.81​
19429.62​	-171.15​
5395.38​	3790.11​
5940.09​	-171.15​
5962.17​	-171.15​
15284.38​	-171.15​
11218.64​	-171.15​

 

[cadandcode]

Do you want to remove "-" symbols or do you want to hide whole result starts with "-" symbol?

 

[annadinesh]

Do you want to remove "-" symbols or do you want to hide whole result starts with "-" symbol?

WHOLE NEGATIVE VALUE

 

[cadandcode]

I dont know which formulas you used in cells. Can you use xl2bb to share your sheet?

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

 

[annadinesh]

I dont know which formulas you used in cells. Can you use xl2bb to share your sheet?

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

formula using in cells

=IF(J1<90,HLOOKUP(D5,EW90DAYS!B2:AA43,22,0)*1.18-N10,HLOOKUP(D5,Database!B2:AA43,22,0)*1.18-N10)

 

[cadandcode]

Please provide your excel data via xl2bb. I dont know how to use your formula.

 

[Sufiyan97]

See if this helps

=IF(IF(J1<90,HLOOKUP(D5,EW90DAYS!B2:AA43,22,0)*1.18-N10,HLOOKUP(D5,Database!B2:AA43,22,0)*1.18-N10)<0,"",IF(J1<90,HLOOKUP(D5,EW90DAYS!B2:AA43,22,0)*1.18-N10,HLOOKUP(D5,Database!B2:AA43,22,0)*1.18-N10))