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
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!
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.
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
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 ?
@@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? .
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
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
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.
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
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
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
@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,"")
@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.
Click below link to learn more with new tips & tricks.
www.youtube.com/@rathpoint?sub_confirmation=1
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
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!
I am glad that it helped you. Thanks.
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.
THANK YOU
Thanks 😊
Thanks a lot bro, been trying for 2 days now it is solved. I owe you one and I'm subscribing. Thanks again! 💪
Thanks 😊
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 ☺️
Thanks Jini 😊 Have a great day.
Thank you soooo much!!!! This was very helpful!! Exactly what I was looking for. God bless you
You are so welcome! Thanks for your comments, it means a lot. Have a great day.
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
Instead of multiple IF functions, use IFS function. Check the short video: ruclips.net/user/shortsHuweiCz97kg?feature=share
Thank you so much, sir. you really helped me ❤❤❤
You're welcome 😊
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 ?
You can use the SUBSTITUTE formula to replace the hyphen. Watch video to know how:
ruclips.net/video/9grf7P3FeK0/видео.html
@@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?
.
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
Ur the best!!!!
@Afriken, thanks 😊 for your comment 😊
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
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.
@@rathpoint Thanks for ur reply,
You are Welcome.
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
You can use the below formula and it will work:
=IF(F6="","",IF(F6>=(TODAY()),"Not Due","Passed Due"))
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
@CVo83, Please use the below formula and let me know if its working for you:
=IF(ISBLANK(H16)=TRUE,"",IF(H16
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
@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,"")
@@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
@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.
@@ayushsharma5267 =if(A2=>0,,"", B2-A2)
How to Ignore if Value is zero?
@Ayush, you can use IF formula or IFS formula. Example, if cell B2 is Zero then =If(B2=0,.....
@@rathpoint wow… Thanku so much. Solved my problem. Used =IF(H3=0,””,H3-G3)…..subscribed your channel.
Thanks Ayush 😊
How do you do this with an average formula?
You can combine the Average Formula with these formulas as per your need. Thanks
@@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?
Send me the sample file at GopalKrRath@gmail.com. Also mention the way you want the result and will fix for you. Thanks
Help
Hope it helped you.
I tried the formula but it still give an error.
Please help
Let me know your formula.
Did you get the video clip?