S
Steved
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.
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.