Hello
I'm trying to take a figure in eg column A1, subtract it from column E1, and then subtract any cells in columns B,C,D on same row...
then have this formula copied right the sheet.
using right click- paste special-formula...(which isn't working)
the formula i'm trying is eg as follows..
A1- E1-(B1:D1)

i've tried this by also inserting the word range before B1 but it doesn't work...any tips....?