|
|
#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
|
