Excel Formula Problem

  Taff™ 16:09 03 Feb 2007
Locked

I am attempting to sort out an invoice spreadsheet to show VAT. Typically I have (For 8 items) a column showing a quantity, A description and a Unit cost. The next column has the formula =IF(SUM(P2*R2)>0,SUM(P2*R2),"")to calculate the extended cost of the item. (Quantity x Unit Cost)

After 8 sets of columns I have put in a formula that reads =SUM(S2+W2+AA2+AE2+AI2+AM2+AQ2+AU2)which adds up all the extended values - except it`s returning a #Value! Obviously I`ve made a mistake! Anyonepoint me in the right direction because I need to evaluate the VAT in a similar way.

  VoG II 16:14 03 Feb 2007

1st formula should be

=IF(P2*R2>0,P2*R2,"")

2nd formula should be

=SUM(S2, W2, AA2, AE2, AI2, AM2, AQ2 ,AU2)

or

=S2+W2+AA2+AE2+AI2+AM2+AQ2+AU2

  Taff™ 16:27 03 Feb 2007

Thanks VOG™ that sorted out the VAT column as well I think! I`ll leave this open for a while and test the rest of the spreadsheet with some dummy figures.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?