Saturday, March 2, 2013

phil_d1111 Spreadsheet -- An Illustration For Subtracting FieldB Value From FieldA Value And Putting Result In FieldC


                                          Google Spreadsheet   Post  #1063
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Mar 2, 2013
user phil_d1111 :(http://productforums.google.com/forum/?zx=d9gpshy1lsr9#!mydiscussions/docs/RXNLIMa3EL8)
i've got three colums

one is the price - another is the VAT - the third is the net cost

is there a way I can make a function for the third column so that
the value of the first column will have the value of the second coumn
subtracted from it and the result automatically appear in third column?
---
ok - am working with a google spreadsheet (via chromebook)

I want to have an algorithm that deducts amount of column B from column A to give a net value in C

-------------------------------------------------------------------------------------------------------
this is a very simple problem ... however since phil_d1111 was having a lot of difficulty with this I thought it was best to do an illustration ... and
just to avoid any ambiguity about Column designations, I have used FieldA, FieldB, and FieldC in the following illustration