Microsoft Office Forums - View Single Post - Subtract value from one cell into another

Thread: Subtract value from one cell into another

View Single Post

Old

01-31-2016, 03:18 AM

otuatail

otuatail is offline

otuatail uses Windows 7 64bit

Windows 7 64bit otuatail uses Office 2007

otuatail uses Office 2007

Office 2007

Competent Performer

The original poster

Join Date: Jun 2012

Posts: 245

otuatail is on a distinguished road

Default

Subtract value from one cell into another

This is not strait forward.

I have a money value in cell A2 I want B2 to subtract a value held in E1 but if the value in A2 is less than the value in E1 it inserts £0.00 into B2

Reply With Quote