Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
PYROnoxx
Godless Horizon.
|
Posted - 2009.03.16 04:50:00 -
[1]
Ok so i could use some help with spreadsheet formule
i have basically a set of calculations decided by embedded if statements that decide what things to multiply together depending on the names of certain rows...
(=IF(Staff!E8="Shift",Month!F4*Rates!$E$6,IF(Staff!E8="Labourer",Month!F4*Rates!$E$4,IF (Staff!E8="Semi",Month!F4*Rates!$E$5,IF(Staff!E8="Skilled",Month!F4*Rates!$E$7,IF(Staff!E8="Supervisor",Month!F4*Rates!$E$8,"Error")))))
Now what I'd like to know.. is can i add to that formula to say if this cell = December to multiply the end result of any of the calculations by 2.5%?
or am i clutching straws with my noob method
(100 mill to first person who solves this for me :))
thanks!
Pyro ----
post with ur main!!! i do..ow wait
|
Crumplecorn
Gallente Eve Cluster Explorations
|
Posted - 2009.03.16 05:02:00 -
[2]
Edited by: Crumplecorn on 16/03/2009 05:02:57 Will adding *IF([cell]="December", 0.025, 1) to the end of what you have there work? -
DesuSigs |
PYROnoxx
Godless Horizon.
|
Posted - 2009.03.16 05:06:00 -
[3]
Originally by: Crumplecorn Edited by: Crumplecorn on 16/03/2009 05:02:57 Will adding *IF([cell]="December", 0.025, 1) to the end of what you have there work?
See ! i knew it would be simple 5 am can't really think atm >.<
As promised 100 mill for you :)
Pyro ----
post with ur main!!! i do..ow wait
|
Intense Thinker
Minmatar
|
Posted - 2009.03.16 05:20:00 -
[4]
Haha, nerds
Pomp FTW!!! |
Lucas Tigh
East Khanid Trading Khanid Trade Syndicate
|
Posted - 2009.03.16 05:34:00 -
[5]
Originally by: Intense Thinker Haha, nerds
Haha, hypocrite -------------------------------------
CCP, make me a winner. |
Tuttomenui II
Gallente BUDAPIG LTD
|
Posted - 2009.03.16 07:08:00 -
[6]
Originally by: Lucas Tigh
Originally by: Intense Thinker Haha, nerds
Haha, hypocrite
Haha, LMFAO
^^ My Signiture is an actual Signiture WOW!!!^^ |
Alex V0X2
Minmatar Exiled. Veritas Immortalis
|
Posted - 2009.03.16 07:38:00 -
[7]
Edited by: Alex V0X2 on 16/03/2009 07:38:12
Originally by: Tuttomenui II
Originally by: Lucas Tigh
Originally by: Intense Thinker Haha, nerds
Haha, hypocrite
Haha, LMFAO
Haha, pyramid ----------------- http://cakematar.wordpress.com/ (epicness in rabbles) |
Karr Blanch
The Nietzian Way
|
Posted - 2009.03.16 07:45:00 -
[8]
Originally by: Alex V0X2 Edited by: Alex V0X2 on 16/03/2009 07:38:12
Originally by: Tuttomenui II
Originally by: Lucas Tigh
Originally by: Intense Thinker Haha, nerds
Haha, hypocrite
Haha, LMFAO
Haha, pyramid
Haha, pointless.
|
Micheal Dietrich
Caldari
|
Posted - 2009.03.16 15:18:00 -
[9]
HAHA c-c-c-combo breaker!
|
ReaperOfSly
Gallente Zetsubou Corp
|
Posted - 2009.03.16 17:48:00 -
[10]
Originally by: Micheal Dietrich HAHA c-c-c-combo breaker!
Haha combo starter. ____________________
|
|
jason hill
Caldari Clan Shadow Wolf Sylph Alliance
|
Posted - 2009.03.16 17:49:00 -
[11]
Ha Ha ....err
destroy everything you touch |
Agah Khan
|
Posted - 2009.03.16 18:16:00 -
[12]
Edited by: Agah Khan on 16/03/2009 18:15:54
Originally by: ReaperOfSly
Originally by: Micheal Dietrich HAHA c-c-c-combo breaker!
Haha combo starter.
haha failed combo sta...ah crap ------------------------------------------------------------------------------------------------ This is Le Poupon, If you're reading this I alt alt posted and f'd it up again.
|
Intense Thinker
Minmatar
|
Posted - 2009.03.16 18:25:00 -
[13]
Edited by: Intense Thinker on 16/03/2009 18:25:23 Hey, quit starting pyramids off me, I don't need this account forum banned too
Pomp FTW!!! |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |