Thank you very much for the very useful information.
@svenkatkadiyam7291Ай бұрын
very uselful
@AnLu_electronics2 ай бұрын
Great. Thanks you. This guide is clear and carefull. Video easy to understand. It is exactly thing I need.
@kashj2372 ай бұрын
why doesnt this work for 00,000 ? it doesnt work for thousands, only higher it works
@Techtap0072 ай бұрын
It is perfectly working for thousands. This will not work for 00,000 because 00,000 will consider zero only.
@chaskawaii66103 ай бұрын
Super useful, thank you.
@TanyaLysachenko3 ай бұрын
Doesn't work!!!
@Techtap0073 ай бұрын
=SUBSTITUTE(A1,",",".")
@AshokX9853 ай бұрын
👍
@lisa0457144 ай бұрын
Thank you was very helpful!
@Unknown-oo9vh5 ай бұрын
How to Substitute the below value from Dot to comma and comma to dot. Value : 2.273,58
@Techtap0075 ай бұрын
One of the Method is use flash fill, which is available in Data- Data tools - Flash Fill
@Techtap0075 ай бұрын
=SUBSTITUTE(A1,".",",")
@Techtap0075 ай бұрын
=SUBSTITUTE(A1,",",".")
@ruthcdsilva5 ай бұрын
Thank you!
@bettymalone37695 ай бұрын
'Promosm'
@ExcelExplorers7866 ай бұрын
Your dedication and capabilities have left me in awe. Any insights for my work?
@LuisMartinez-sz1nu6 ай бұрын
Thank you for these videos. I have a question do you know SQL I am becoming a data analyst and this is extremely helpful
@Techtap0076 ай бұрын
Thank you for your comment. No i do not know SQL.
@dellmarco6 ай бұрын
THANKS!!!!!!
@mellitabarretto73457 ай бұрын
Very helpful, thank you very much.😊
@juliahicksfav10 ай бұрын
thank you so much, it worked! Not even ChatGPT could help me on this one
@MukeshKumar-wq7xw11 ай бұрын
Awesome
@MukeshKumar-wq7xw11 ай бұрын
Incredible sir 🎉
@jonathan10melo11 ай бұрын
Thanks a lot!!!!!!
@pathanismail11 ай бұрын
Is this Tapas sir ?
@Techtap00711 ай бұрын
Yes, How are you?
@pathanismail11 ай бұрын
@@Techtap007 it feels great to have you on youtube
@younimoon9567 Жыл бұрын
sorry not helpfull
@Techtap007 Жыл бұрын
Let me know what exactly you are looking for?
@Tushm270 Жыл бұрын
Page break krne ke bad series b har page par 1 s shuru s ho to kse hoga
@Techtap007 Жыл бұрын
If you're asking. The serial number has been inserted automatically by the Microsoft Excels, after you're using page break. Generally, page break is related to page preview for print out. It will not change any data in your Excel file. You must do it manually. Thank you.
@nicolevillacorta4865 Жыл бұрын
thank you!
@Techtap007 Жыл бұрын
You're welcome!
@petersnow5726 Жыл бұрын
😑 "Promo SM"
@nidhithakker5652 Жыл бұрын
Thank you sir
@moogu_ Жыл бұрын
Thank you so much for making this:)
@Techtap007 Жыл бұрын
You're so welcome!
@bernadettegamboa4684 Жыл бұрын
I have MS365 and I do not have this option.
@Techtap007 Жыл бұрын
This is available in installed version. Otherwise you can go to the insert and insert picture.
@tarunbrahmabhatt2711 Жыл бұрын
How can draw a dynamic line between two strike price acording spot price and than spot price change line also change our place in option chain in google sheet how do it
@Techtap007 Жыл бұрын
To draw a dynamic line between two strike prices according to the spot price in Google Sheets, you can use a combination of functions and conditional formatting. Here are the steps: 1. Create a table with the strike prices, option premiums, and any other relevant data. 2. In a separate cell, enter the current spot price. 3. Using the "IF" function, create a new column that compares the spot price to the strike prices. For example, if the spot price is greater than the strike price, the function should return "Above", and if the spot price is less than the strike price, the function should return "Below". 4. Apply conditional formatting to the strike prices column based on the results of the IF function. For example, you can use a green fill color for strike prices that are "Above" the spot price, and a red fill color for strike prices that are "Below" the spot price.
@Techtap007 Жыл бұрын
=IF(A1>$C$1,TRUE,FALSE) Note: Here, A1 is the first cell of the strike prices column, and $C$1 is the cell containing the spot price. You can adjust these cell references as per your requirement.
@tarunbrahmabhatt2711 Жыл бұрын
I want a dynamic line between two which strike near spot not colour how can add line in google sheet