Results 1 to 7 of 7

Thread: Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Nov:2009
    Location:
    Posts: 2

    Excel

    !!!
    ,
    :

    500 1 1 "40100"
    500 400 - "4080"
    400 300 - "4060"
    300 250 - "4040"
    250 - "4020"

    !
    !

  2. #2
    Drinkin' Master todorpavlov's Avatar
    Join Date: Jun:2006
    Location: Batak, Bulgaria
    Posts: 373
    :

    Code:
    =IF(A1<250;"40x20";IF(A1<=300;"40x40";IF(A1<=400;"40x60";IF(A1<=500;"40x80";IF(A1>500;"40x100";)))))
    B1, 1

    ( 1 40x20), , ...
    Last edited by todorpavlov; 26th November 2009 at 01:11.
    MB: ASRock K7 EZ upgrade | CPU: AMD Athlon XP 2200+ clocked to 2800+ | VC: ATi Radeon 9550 | RAM: 2x A-DATA 256 MB in Dual Channel Mode | HDD: Exelsor 80GB + Seagate 120 GB | TV tuner: PlayTV Pro2 | DVD-RW: NEC 3550 CD-RW: LG 8525B | LanCard: Compaq NC3121 10/100MB |

  3. #3
    Registered User aniuta's Avatar
    Join Date: Apr:2004
    Location:
    Posts: 1,058
    Quote Originally Posted by todorpavlov View Post
    ( 1 40x20), , ...
    Code:
    =IF(A1<=0;"";IF(A1<250;"40x20";IF(A1<=300;"40x40";IF(A1<=400;"40x60";IF(A1<=500;"40x80";IF(A1>500;"40x100";))))))
    Last edited by aniuta; 26th November 2009 at 10:54.
    ... , ,
    , ... ?

  4. #4
    Drinkin' Master todorpavlov's Avatar
    Join Date: Jun:2006
    Location: Batak, Bulgaria
    Posts: 373
    Quote Originally Posted by aniuta View Post
    Code:
    =IF(A1<=0;"";IF(A1<250;"40x20";IF(A1<=300;"40x40";IF(A1<=400;"40x60";IF(A1<=500;"40x80";IF(A1>500;"40x100";))))))

    , " 250", ...


    @evlogi: , , "300" 4040 4060, 250, 400, 500
    Last edited by todorpavlov; 26th November 2009 at 14:18.
    MB: ASRock K7 EZ upgrade | CPU: AMD Athlon XP 2200+ clocked to 2800+ | VC: ATi Radeon 9550 | RAM: 2x A-DATA 256 MB in Dual Channel Mode | HDD: Exelsor 80GB + Seagate 120 GB | TV tuner: PlayTV Pro2 | DVD-RW: NEC 3550 CD-RW: LG 8525B | LanCard: Compaq NC3121 10/100MB |

  5. #5
    M.A.V.O. Member Tele_Santana's Avatar
    Join Date: Jun:2005
    Location: downtown
    Posts: 205
    , nested IFs excel, AND.
    <Gigabyte 8I945P Pro> <Intel P-D 930> <2x1 GB Crsair DDR2 667> <Galaxy GF 7300GT>

  6. #6
    Registered User
    Join Date: Nov:2009
    Location:
    Posts: 2
    - !!!!

    ---------- 21:40 ---------- 18:16 ----------



    =SUM(D8-22)/5+1 2- ?
    !

    ---------- 21:53 ---------- 21:40 ----------



    =SUM(D8-22)/5+1 2- ?
    !

  7. #7
    Banned
    Join Date: Jun:2008
    Location:
    Posts: 1,880
    Quote Originally Posted by evlogi View Post
    =SUM(D8-22)/5+1 2- ?
    !
    =ROUND(SUM(D8-22)/5+1;2)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |