GoFuckYourself.com - Adult Webmaster Forum - HELP! with one formula in excel...

- Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)

- - HELP! with one formula in excel... (https://gfy.com/showthread.php?t=430307)

spamofon

02-11-2005 10:08 AM

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?

tungsten

02-11-2005 10:12 AM

bump, not big on excel myself

spamofon

02-11-2005 10:16 AM

nevermind

spamofon

02-11-2005 10:17 AM

=if(c45<10000,0.2*c45,0.3*c45)

ShaneRyale

02-11-2005 10:18 AM

Here you go.

=IF(C4 > 10000,C4*0.3+C4,C4*0.2+C4)

spamofon

02-11-2005 10:42 AM

How to make a Formula View of the spread sheet?

spamofon

02-11-2005 11:48 AM

Quote:

Originally Posted by spamofon

How to make a Formula View of the spread sheet?

:warning

All times are GMT -7. The time now is 03:09 PM.