|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
02-11-2005, 10:08 AM
|
#1 |
|
Confirmed User
Join Date: Jun 2003
Location: Toronto
Posts: 2,999
|
HELP! with one formula in excel...
i need to write this
IF C4 > 10000 , then C4*0.3+C4 IF C4< 10000, then C4*0.2+C4 how do i put it in one line? |
|
|
|
02-11-2005, 10:12 AM
|
#2 |
|
Too lazy to set a custom title
Join Date: Mar 2004
Posts: 10,579
|
bump, not big on excel myself
__________________
|
|
|
|
|
02-11-2005, 10:16 AM
|
#3 |
|
Confirmed User
Join Date: Jun 2003
Location: Toronto
Posts: 2,999
|
nevermind
|
|
|
|
|
02-11-2005, 10:17 AM
|
#4 |
|
Confirmed User
Join Date: Jun 2003
Location: Toronto
Posts: 2,999
|
=if(c45<10000,0.2*c45,0.3*c45)
|
|
|
|
|
02-11-2005, 10:18 AM
|
#5 |
|
Confirmed User
Join Date: Mar 2004
Posts: 961
|
Here you go.
=IF(C4 > 10000,C4*0.3+C4,C4*0.2+C4)
__________________
Shane - Affiliate Manager [email protected] ICQ: 170164556 See Who I Am At AdultWhosWho.com! 
|
|
|
|
|
02-11-2005, 10:42 AM
|
#6 |
|
Confirmed User
Join Date: Jun 2003
Location: Toronto
Posts: 2,999
|
How to make a Formula View of the spread sheet?
|
|
|
|
|
02-11-2005, 11:48 AM
|
#7 | |
|
Confirmed User
Join Date: Jun 2003
Location: Toronto
Posts: 2,999
|
Quote:
 |
|
|
|
|
