|
| |||||||
|
| |
 |
| | LinkBack | Thread Tools |
|
#1
17th Feb 2008
| ||||
| ||||
 =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
| ||||||||||||
| ||||||||||||
| =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
Want your system info in your signature? |
|
#3
17th Feb 2008
| ||||
| ||||
| =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
| ||||||||||||
| ||||||||||||
| =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 My System: hAvAAck Build 3
Want your system info in your signature? |
|
#5
17th Feb 2008
| ||||
| ||||
| =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! |
|
#6
17th Feb 2008
| ||||||||||||
| ||||||||||||
| =IF formula yeah if this, then this, else that
__________________
My System: hAvAAck Build 3
Want your system info in your signature? |
|
|
| Thread Tools | |
|
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel Formula - VLookups :s | Jonathon28 | Office Suites & Applications | 1 | 1st May 2008 08:14 PM |
| Excel Formula Help | Jonathon28 | Office Suites & Applications | 6 | 22nd Feb 2008 03:36 PM |
| Asus Striker 2 Formula, some questions | codymackay | CPUs, Motherboards & RAM | 5 | 11th Feb 2008 12:24 AM |
| Powered by vBulletin® Copyright ©2000 - 2008 Jelsoft Enterprises Ltd. SEO by vBSEO ©2008, Crawlability, Inc. |
