|
|
#1
17th Feb 2008, 07:01
| |||
| |||
| I was wondering IF you could help me  I am trying to work out a formula which when a check box is checked shows the total price with VAT added on: like this: =IF(G26="TRUE",=SUM(H28*0.175) (cell link for check box is G26) trying various combinations of the above but no luck! Many thanks in advance! |
|
#2
17th Feb 2008, 07:59
| ||||||||||||
| ||||||||||||
| it's always advisable to upload a sample spreadsheet so we don't need to reproduce it to help
__________________
My System: hAvAAck Build 3
|
|
#3
17th Feb 2008, 08:44
| |||
| |||
| Thank you for your advice hAvAAck. I thought it might be useful after I started the thread, but then got caught up repairing a desktop for someone. |
|
#4
17th Feb 2008, 08:57
| |||
| |||
| =IF(G26, H28*0.175, 0) is that what you're looking for? if the box is checked, we add on .175 of the subtotal to the total |
|
#5
17th Feb 2008, 09:09
| |||
| |||
| yes that is what i wanted. Sorry I have just realised how simple that was. 'value if true, value if false' Thank you! |
|
#6
17th Feb 2008, 09:10
| |||
| |||
| yeah if this, then this, else that |
 |
 |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Asus Maximus II Formula PC build | mizsua | CPUs, Motherboards & RAM | 7 | 9th Jan 2009 16:44 |
| Help with Excel formula please | robbie73 | Office Suites & Applications | 2 | 10th Sep 2008 11:00 |
| Excel Formula - VLookups :s | Jonathon28 | Office Suites & Applications | 1 | 1st May 2008 12:14 |
| Excel Formula Help | Jonathon28 | Office Suites & Applications | 6 | 22nd Feb 2008 08:36 |
| Asus Striker 2 Formula, some questions | codymackay | CPUs, Motherboards & RAM | 5 | 10th Feb 2008 17:24 |
| Thread Tools | |
| |
