![]() |
|
|||||||
|
|
|
|
|
|
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!
...
|
![]() |
|
|
Thread Tools |
|
#1
|
|||
|
|||
|
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
|
||||||||||||
|
||||||||||||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
=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
|
|||
|
|||
|
yes that is what i wanted. Sorry I have just realised how simple that was.
'value if true, value if false' Thank you! |
|
#6
|
|||
|
|||
|
yeah if this, then this, else that
|
![]() |
|
| Bookmarks |
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 | |
|
|