Microsoft Office Forums - View Single Post - Need to calculate a result if a number is positive or negative.

Thread: Need to calculate a result if a number is positive or negative.

View Single Post

Old

02-28-2019, 07:29 AM

bosco_yip

bosco_yip is offline

bosco_yip uses Windows 10

Windows 10 bosco_yip uses Office 2016

bosco_yip uses Office 2016

Office 2016

Novice

Join Date: Feb 2019

Location: Singapore

Posts: 7

bosco_yip is on a distinguished road

Default

Perhaps,

In E9, copied down :

=IF(D9<>"",D9+E9,"")

Regards
Bosco

Reply With Quote