|
|
#1
04-03-2013, 03:20 PM
|
|||
|
|||
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.. 
|
|
#2
04-03-2013, 06:33 PM
|
||||
|
||||
|
Welcome to the forum. Try:
=IF(C9>2000,5%,3%)
|
|
#3
04-04-2013, 01:58 PM
|
|||
|
|||
|
thanks
thanks very much colin much appreciated..
|
|
| 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 |
Windows XP 
Office 2010 32bit
Linear Mode
