Click below link to learn more with new tips & tricks. www.youtube.com/@rathpoint?sub_confirmation=1
@harish7041Ай бұрын
Can we use if function instead minus please show me how to do it ,and show how to compare number and text combination to get if function For example if coloumn C4 contione 500 and D4 contains true word I should get valid text in E5
@valmir144 Жыл бұрын
How come no one has ever explained this stuff but you? I've been googling for "how to not show zeros when there is a formula not returning any value" and everyone was explaining how to not show zeros in different ways etc etc. What you are explaining is exactly what I have been looking for for so long! Damn! Thanking you will never be enough!
@rathpoint Жыл бұрын
I am glad that it helped you. Thanks.
@leadmanalo621810 ай бұрын
Thanks a lot bro, been trying for 2 days now it is solved. I owe you one and I'm subscribing. Thanks again! 💪
@rathpoint10 ай бұрын
Thanks 😊
@retooluvyuhx5569 Жыл бұрын
Thank you soooo much!!!! This was very helpful!! Exactly what I was looking for. God bless you
@rathpoint Жыл бұрын
You are so welcome! Thanks for your comments, it means a lot. Have a great day.
@jinit80832 жыл бұрын
I was wondering how to do this but don’t have much experience with Excel. You provided a great tutorial. Thanks. Also subscribed to your channel ☺️
@rathpoint2 жыл бұрын
Thanks Jini 😊 Have a great day.
@rathpoint3 жыл бұрын
SUBSCRIBE: Please subscribe to our channel for more useful videos. LIKE, SHARE & COMMENT: Your comment will motivate us to add more and more videos and will resolve your queries.
@reina.h10538 ай бұрын
Thank you so much, sir. you really helped me ❤❤❤
@rathpoint8 ай бұрын
You're welcome 😊
@TheCass2212 ай бұрын
THANK YOU
@rathpoint2 ай бұрын
Thanks 😊
@afrikenofficial33082 жыл бұрын
Ur the best!!!!
@rathpoint2 жыл бұрын
@Afriken, thanks 😊 for your comment 😊
@harish7041Ай бұрын
Can we use if function instead minus please show me how to do it ,and show how to compare number and text combination to get if function For example if coloumn C4 contione 500 and D4 contains true word I should get valid text in E5
@rathpointАй бұрын
Instead of multiple IF functions, use IFS function. Check the short video: kzbin.infoHuweiCz97kg?feature=share
@watcher48877 ай бұрын
Sir, I have an assignment from an institute and it's really a long one, the empty cells in the sheet are filled with a hyphen because of that the formula is not ignoring the cells can you advise how to make a formula to ignore cells with a hyphen please ?
@rathpoint7 ай бұрын
You can use the SUBSTITUTE formula to replace the hyphen. Watch video to know how: kzbin.info/www/bejne/b5jVl2qGaKuYgZI
@watcher48877 ай бұрын
@@rathpoint Thank you! I have to ask you one more favor please, I am in a calculation and there are blank cells, excel delivers the result at the correct cells but picks up the wrong cells for the calculation at cell K10 being the first cell for the formula which is =IF(B10="","", P$4*B3+(1-P$4)*K3) is giving correct result but after dragging down the second cell K15 is 0, K20 is value error K26 is value error till the end of the sheet. I checked the formula on these cells and found Excel picking up different cells. The formula at K15(second place) is =IF(B15="","",P$4*B8+(1-P$4)*K8) here B15 is correct next two cells b10( b8 wrong) and k10 (k8wrong)similarly next point at K20 is i=IF(B20="","",P$4*B13+(1-P$4)*K13) here also b20 is correct b15 k15(b13,k13 wrong). Can you suggest any solution for this, please? .
@rathpoint6 ай бұрын
You have made absolute to row numbers so its getting fixed. For example in P$4, the column P will change but row 4 will be fixed and will not change. Double check which row or column you want to add absolute then the formula will work fine. Thanks
@chethuawangproductions66542 жыл бұрын
For Marksheet If one of the cell is blank in Subject column , then not to calculate in Total mark column for blank cell. Please help me which formula to use
@rathpoint2 жыл бұрын
For blanks you can use ISBLANK formula and to calculate sum with conditions you can use SUMIFS formula. You can also try XLOOKUP if you have Office 365.
@chethuawangproductions66542 жыл бұрын
@@rathpoint Thanks for ur reply,
@rathpoint2 жыл бұрын
You are Welcome.
@CVo832 жыл бұрын
If I want to the result of the cell to say Yes if the date in one cell is less than or equal to the date in another cell, and exclude blanks, how would I write that? I currently have: IF(H16
@rathpoint2 жыл бұрын
@CVo83, Please use the below formula and let me know if its working for you: =IF(ISBLANK(H16)=TRUE,"",IF(H16
@ayushsharma52672 жыл бұрын
I want to add some cells of excel but some have negative value. Can you please guide me how to ignore those cells which have (-) value as I only want to calculate which have value above than 0
@rathpoint2 жыл бұрын
@Ayush, you can do that easily using IF formula. For example if cell A2 is having value then keep formula as: =if(A2>0,A2,"") If you want 0 also then, use below formula: =if(A2=>0,A2,"")
@ayushsharma52672 жыл бұрын
@@rathpoint sorry to say but its not working…All values are in the same column and want the total of that column which have value above than 0
@rathpoint2 жыл бұрын
@Ayush, may be you are keeping wrong cell references in formula. Send me the sample at GopalKrRath@gmail.com, let me know where you want the formula and what exactly you need.
@securesquare2 жыл бұрын
@@ayushsharma5267 =if(A2=>0,,"", B2-A2)
@hugogarcia268111 ай бұрын
I have formula IF=(F6>=(TODAY(),"Not Due","Passed Due") but I'm trying to make it stay blank if there is no data yet with IF=F6="",""'(F6>=(TODAY(),"Not Due","Passed Due") but it comes as an error
@rathpoint11 ай бұрын
You can use the below formula and it will work: =IF(F6="","",IF(F6>=(TODAY()),"Not Due","Passed Due"))
@Shirodx Жыл бұрын
How do you do this with an average formula?
@rathpoint Жыл бұрын
You can combine the Average Formula with these formulas as per your need. Thanks
@Shirodx Жыл бұрын
@@rathpoint I’ve tried and would get an error that said there were too many functions. Is there a way to see an example of the formula?
@rathpoint Жыл бұрын
Send me the sample file at GopalKrRath@gmail.com. Also mention the way you want the result and will fix for you. Thanks
@ayushsharma52672 жыл бұрын
How to Ignore if Value is zero?
@rathpoint2 жыл бұрын
@Ayush, you can use IF formula or IFS formula. Example, if cell B2 is Zero then =If(B2=0,.....
@ayushsharma52672 жыл бұрын
@@rathpoint wow… Thanku so much. Solved my problem. Used =IF(H3=0,””,H3-G3)…..subscribed your channel.