excel formula Help with value great than then include value with negative

[Lukma]

Hi Guys

i was wondering if its possible to have a two value display negative sign on another cell

am having a Value in Colum A 1 = 6 and in Cell A2 = 8, without any negative sign, what am trying to achieve is that in Column B1 and 2 beside each other i need if A2 is greater than A1 if yes the it should return Cell A2 as -8 and if not then to remain same.

Is there any solution formula that could get this done

Appreciate if there is

Hrs
6
8	Greater Than A2	-8
	If Not greater than	8

 

[Saurabhj]

Hi Lukma,

Please check below:

=IF(A2>A1,0-A2,A2)

imagecontrol.xlsm
	A	B
1	6
2	8	-8
Sheet3

Cell Formulas
Range	Formula
B2	B2	=IF(A2>A1,0-A2,A2)

 

[Lukma]

Hi Saurabhj

Awesome just as i needed, i have been trying to figure it out so much cool

Thanks

 

[Lukma]

Saurabhj​

Can this formal work out on Time Format

ILSP KPI Performance Tracking.xlsx
	J	K	L
3	ADOF Operation Downtime		9:35
4	ADL&S Operation Downtime		5:21
5	Supplier Ex-trailer Downtime		67:49
ILSP_KPI_Tracking_Data_Entry

Cell Formulas
Range	Formula
L3	L3	=IFERROR(AVERAGEIF(E10:E14,">0"),"")
L4	L4	=AVERAGEIFS(DZ18:DZ60000,DF18:DF60000,B9,DZ18:DZ60000,">0")
L5	L5	=SUMIFS($EB$18:$EB$60000,$DF$18:$DF$60000,$B$9)

 

[Saurabhj]

Hi Lukma,

Thanks for the feedback.

Can you please explain your query.
What is the expected output?
L5 is showing 67:49, is this indicating time ?

Thanks,
Saurabh

 

[Lukma]

Saurabhj

Thanks for your feedback i actually need the output of L3 and L4 only
that means if L3 is greater than L4 then L3 should return same time but with a negative sign

i tried using same formula but cant seems to find my way around it with time format

9:25​	-9:25
5:21​

 

[Saurabhj]

Hi Lukma,

Use below:

=IF(L3>L4,L3*-1,L3)

And select check box "Use 1904 date System" in Excel Options (File -> Options).
(See screenshot)

 

[Lukma]

Thanks So Much Saurabhj

It works