Results 1 to 2 of 2

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User GreenLife's Avatar
    Join Date: Jul:2010
    Location: Bulgaria :)
    Posts: 26

    Çàäà÷êà â Excel

    Çäðàâåéòå, èìàì åäíà çàäà÷êà â åêñåë, êîÿòî íå ìîãà äà ðåøà.Íå ðàçáèðàì è ìå çàòðóäíÿâà, çàòîâà ùå âè ïîìîëÿ çà ìàëêî ïîìîù.





    îòñòúïêà (G5:G13) ñå ïîëàãà, ñàìî àêî äàòàòà íà ïîëèöàòà å
    ïðåäè 25.12.2011 ã. Òÿ ñå èç÷èñëÿâà ïî ôîðìóëàòà:
    Çàñòðàõîâàòåëíà ïðåìèÿ * Ïðîöåíò íà îòñòúïêà
    Ïðîöåíòúò íà îòñòúïêà å â êëåòêà G2.



    Áëàãîäàðÿ ïðåäâàðèòåëíî.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	image.7TKY8W.png‎ 
Views:	128 
Size:	43.1 KB 
ID:	66150  

  2. #2
    Registered User
    Join Date: Sep:2007
    Location: Sofia
    Posts: 368
    Çäðàâåé,
    ôîðìóëàòà å =IF(E5<DATE(2011;12;25); F5*G2; F5)
    Îãëåäàé ñàìî äà íå ñúì îáúðêàë íÿêîÿ êëåòêà ñàìî.
    Ïðåâåäåíî òîâà îçíà÷àâà :Àêî êëåòêà E5 e ïî-ìàëêà îò åäèêîÿ ñè äàòà óìíîæè êëåòêà F5 ñ G2, àêî å ïî-ãîëÿìà ïîêàæè ñàìî ñòîéíîñòòà íà êëåòêà F5.
    Óñïåõ

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 | Ìàãàçèí çà åëåêòðîííè öèãàðè