lesser-equity

Magazine
Go Back   Computer Juice > Computer Software > Office Suites & Applications


Register


Reply
 
Thread Tools
  #1  
Old 17th Feb 2008, 07:01
Member Group
 
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  
Old 17th Feb 2008, 07:59
Donor Group
 
it's always advisable to upload a sample spreadsheet so we don't need to reproduce it to help
__________________

My System: hAvAAck Build 3

Processor(s):
Intel Core 2 Duo E6750 @ 2.67GHz
Motherboard:
Asus P5N-E
RAM Memory:
GSkill 4GB DDR2
Graphics Card(s):
EVGA Nvidia e-GeForce 8600GT
Sound Card:
onboard
Hard Drive(s):
Samsung 500GB @ 7200rpm
Optical Drive(s):
Dead
Case / PSU:
Generic Case, Generic PSU
Cooling:
Zalman 92mm
Network / Internet:
onboard
Monitor(s):
Dell 2408WFP Ultrasharp 2048 24"
Operating System(s):
MS Vista Ult, Ubuntu 7.10 64-Bit
  #3  
Old 17th Feb 2008, 08:44
Member Group
 
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.
Attached Files
File Type: xls sample_spreadsheet.xls (22.5 KB, 5 views)
  #4  
Old 17th Feb 2008, 08:57
Donor Group
 
=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  
Old 17th Feb 2008, 09:09
Member Group
 
yes that is what i wanted. Sorry I have just realised how simple that was.

'value if true, value if false'

Thank you!
  #6  
Old 17th Feb 2008, 09:10
Donor Group
 
yeah if this, then this, else that
Reply

Register
Thread Tools




Arabic Bulgarian Chinese (Simplified) Chinese (Traditional) Croatian Czech Danish Dutch English Finnish French German Greek Hebrew Hungarian Italian Japanese Korean Latvian Lithuanian Norwegian Polish Portuguese Romanian Russian Serbian Slovak Spanish Swedish Thai Turkish Ukrainian

Copyright ©2006 - 2009 Computer Juice.

Powered by vBulletin® Copyright ©2000 - 2009 Jelsoft Enterprises Ltd. SEO by vBSEO ©2009, Crawlability, Inc.