|
|
#1
17th Feb 2008, 06:01
|
|||
|
|||
=IF formula
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, 06:59
|
||||||||||||
|
||||||||||||
|
=IF formula
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, 07:44
|
|||
|
|||
|
=IF formula
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, 07:57
|
|||
|
|||
|
=IF formula
=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, 08:09
|
|||
|
|||
|
=IF formula
yes that is what i wanted. Sorry I have just realised how simple that was.
'value if true, value if false' Thank you! |
 |
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| 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 07:36 |
| Asus Striker 2 Formula, some questions | codymackay | CPUs, Motherboards & RAM | 5 | 10th Feb 2008 16:24 |
| Tags |
| formula |
| Bookmarks |
| Thread Tools | |
|
|
