Formula to calculate either "-" "+"
 

Hello from Steved

In Sheet 1

Column T:T
Cell T3 I have Short
Cell T4 I have Over
Cell T5 I have a negative or positive Number (ie "-4" or "4 "

In Sheet 2

Cell H8 "=IF($A$8="Drivers ( Short )",'Drivers Establishment Figures'!$T$5,0)"
Cell H9 "=IF($A$9="Drivers ( Over )",'Drivers Establishment Figures'!$T$5,0)"

Objective please is if cell T5 has "-4" then input into Cell "H8"
or if cell T5 has "4" then input into Cell "H9"

Thankyou.

Formula to calculate either "-" "+"
 

Do you mean

In H8
=IF('Drivers Establishment Figures'!$T$5<0,'Drivers Establishment
Figures'!$T$5,"")

In H9
=IF('Drivers Establishment Figures'!$T$50,'Drivers Establishment
Figures'!$T$5,"")

If this post helps click Yes
---------------
Jacob Skaria


"Steved" wrote:

Hello from Steved

In Sheet 1

Column T:T
Cell T3 I have Short
Cell T4 I have Over
Cell T5 I have a negative or positive Number (ie "-4" or "4 "

In Sheet 2

Cell H8 "=IF($A$8="Drivers ( Short )",'Drivers Establishment Figures'!$T$5,0)"
Cell H9 "=IF($A$9="Drivers ( Over )",'Drivers Establishment Figures'!$T$5,0)"

Objective please is if cell T5 has "-4" then input into Cell "H8"
or if cell T5 has "4" then input into Cell "H9"

Thankyou.

Formula to calculate either "-" "+"
 

Hello Jacob

Thanks for timeout on my issue

I did what you advised but it only worked on the less <0 not on 0



"Jacob Skaria" wrote:

Do you mean

In H8
=IF('Drivers Establishment Figures'!$T$5<0,'Drivers Establishment
Figures'!$T$5,"")

In H9
=IF('Drivers Establishment Figures'!$T$50,'Drivers Establishment
Figures'!$T$5,"")

If this post helps click Yes
---------------
Jacob Skaria


"Steved" wrote:

Hello from Steved

In Sheet 1

Column T:T
Cell T3 I have Short
Cell T4 I have Over
Cell T5 I have a negative or positive Number (ie "-4" or "4 "

In Sheet 2

Cell H8 "=IF($A$8="Drivers ( Short )",'Drivers Establishment Figures'!$T$5,0)"
Cell H9 "=IF($A$9="Drivers ( Over )",'Drivers Establishment Figures'!$T$5,0)"

Objective please is if cell T5 has "-4" then input into Cell "H8"
or if cell T5 has "4" then input into Cell "H9"

Thankyou.