Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-03-2013, 03:20 PM
MARK SMITH MARK SMITH is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Apr 2013
Location: LLANDUDNO
Posts: 2
MARK SMITH is on a distinguished road
Default IF formula

can anyone please tell me the order of this IF formula for this question please? if cell C9 is more than 2000 5% 3% if not??
i know it starts =IF(C9>2000,5% but thats about it?

many thanks... Mark..
Reply With Quote
  #2  
Old 04-03-2013, 06:33 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 381
Colin Legg will become famous soon enough
Default

Welcome to the forum. Try:

=IF(C9>2000,5%,3%)
Reply With Quote
  #3  
Old 04-04-2013, 01:58 PM
MARK SMITH MARK SMITH is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Apr 2013
Location: LLANDUDNO
Posts: 2
MARK SMITH is on a distinguished road
Default thanks

thanks very much colin much appreciated..
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula help furface00 Excel 10 02-26-2012 05:34 AM
help with a look up or if formula beb1227 Excel 3 12-31-2011 01:08 PM
PMT Formula OneOleGuy Excel 4 03-05-2011 09:54 AM
Help for formula dehann Excel 5 05-01-2009 10:44 AM
Need help with a formula tinkertron Excel 11 04-16-2009 11:43 PM


All times are GMT -7. The time now is 06:28 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft