Results 1 to 7 of 7
Thread: Excel
Hybrid View
-
25th November 2009 23:35 #1Registered User
Join Date: Nov:2009
Location:
Posts: 2
Excel
!!!
,
:
500 1 1 "40100"
500 400 - "4080"
400 300 - "4060"
300 250 - "4040"
250 - "4020"
!
!
-
26th November 2009 00:59 #2
:
B1, 1Code:=IF(A1<250;"40x20";IF(A1<=300;"40x40";IF(A1<=400;"40x60";IF(A1<=500;"40x80";IF(A1>500;"40x100";)))))
( 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 |
-
26th November 2009 10:49 #3
-
26th November 2009 14:07 #4
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 |
-
26th November 2009 01:13 #5
, nested IFs excel, AND.
<Gigabyte 8I945P Pro> <Intel P-D 930> <2x1 GB Crsair DDR2 667> <Galaxy GF 7300GT>
-
26th November 2009 21:53 #6Registered 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- ?
!
-
26th November 2009 21:56 #7Banned
Join Date: Jun:2008
Location:
Posts: 1,880




Reply With Quote

R9 280,
7th May 2023, 21:28 in