V harku 1 mám kopec čísel a do hárku 2 mám dať iba tie, ktoré sú rovné hodnote milión alebo väčšej a zároveň ich vynásobiť miliónom. Nechcem ísť bunku po bunke, čiže sa pokúšam prísť na nejakú funkciu.
Moj postup je nasledovny:
1.absolutna hodnota cisla
2.zaokruhli bez desatinych cisel
=ABS((ROUND('2019'!B4,0)))
3.spocita znaky v bunke
=LEN('ABS+Round'!B4)
4.ak je vacsie, tak napise 1 ak nie tak 0
=IF((LEN(ABS((ROUND('2019'!AB36,0))))>6),1,0)
5.ak je 1 tak vynasobi 1000000
Bod 5 však neviem vyriesit. Prve 4 body sa mi podarilo dat do jednej funkcie ....... =IF((LEN(ABS((ROUND('2019'!O34,0))))>6),1,0) ......... no ten posledny bod mi robi problem.
Resp. existuje iny mozno jednoduchsi sposob?
Are you looking for Microsoft Office tutoring? Find the right Microsoft Office tutor for online or in-person tutoring near you.
We access the information stored on your device for this website to function properly. This includes, for example, cookies or local browser cache. We use this to store the data necessary for the functioning of the website, data used for analytical purposes, or data stored by third parties.
If this information is essential for the operation of this website, we store it automatically. For everything else, we need your consent, which you can choose to give below. Your consent is valid for 12 months. Should you refuse, we will ask you for consent again in 6 months, but you are free to change your mind at any time. For more information, please see our GDPR and Terms of Use.