deeler Posted January 21, 2009 Report Share Posted January 21, 2009 (edited) Nesmu ipasi pieredzejis ar so programmu, un ir vajadziga palidziba. Majasdarbs informatika, bet nezinu ko darit. Tadel ludzu lai jus man izpalidzat. 1. Kada formula ir jaizmanto lai rutina uzliktu limitu kadi skaitli var tikt ievaditi. Piemeram rutina drikstes ievadit tikai no skaitla 0 lidz 900? 2. Kada formula ir jaizmanto lai, ja es viena rutina pamainu skaitli, tad cita, manis noteikta rutina, ari tiks pamainits uz manis noteikto skaitli? Piemers: Ja rutina A1 skaitlis lielaks par 250, tad rutina A2 skaitlis pamainas no 65 uz 70. Edited January 22, 2009 by deeler Link to comment Share on other sites More sharing options...
Kiwix Posted January 22, 2009 Report Share Posted January 22, 2009 Tur bija tā funkcija "IF"... Link to comment Share on other sites More sharing options...
X ID Posted January 22, 2009 Report Share Posted January 22, 2009 2. Šūnā A2 =IF(A1>250;70;65) Link to comment Share on other sites More sharing options...
deeler Posted January 22, 2009 Author Report Share Posted January 22, 2009 (edited) Paldies liels, tagad tikai tas pirmais ir atlicis. Es varbut neskaidri esmu izteicies. Rekur ir viss jautajums kas ierakstits "2. To reduce data entry errors, change the 'Number of Items Sold' column so that people cannot enter numbers smaller than 0 or greater than 900. " ceru ka sapratisiet. EDIT:: Tomer google atradu. Ja jums ari kadreiz vaig zinat ka so var izdarit, ejiet uz http://www.selfseo.com/story-16740.php Edited January 22, 2009 by deeler Link to comment Share on other sites More sharing options...
Recommended Posts