| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW CAN I SET UP IF AMOUNT IN COL A = 0 THEN ADD B COL
Hi can anyone help me I am trying to work out a VAT return short cut
if my col A has a total of 0.00 in it I want to add its number next door in B i.e. a1 2.50 b1 3.50 a2 0.00 b2 4.40 a3 3.00 b3 2.00 total I am looking for is 4.40 I hope this makes sense |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to convert the amount in currency into the amount in words? | Excel Discussion (Misc queries) | |||
| Formula for amount owing subtract amount paid | Excel Worksheet Functions | |||
| How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
| Converting amount in figures to amount in words | Excel Discussion (Misc queries) | |||
| How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
Threaded Mode
