Hi Chester - thanks for this. How would you make the operators dynamic in the formula (i.e. >,). If some of my thresholds need to be greater than a certain value, whilst others less than. Many thanks!
Thank you for this. Is it possible to change the same column, no column C. Ex: anything in columb B greater the 150 will change to" >150". Thank you kindly
Hi sir, am watching all ur excel videos it's very helpful for us, pls help to get one formula with if, if A1 is =>2 then it should give 2, if A1 is =>11.25 then it should give max limit of 11.25, meanwhile if the value in between 2 to 11.25 it should give the between value, example if 5 means ans should be 5, only when it goes more than 11.25 it should show only 11.25, pls reply sir
In cell D99 of the August Sales worksheet, use a function to display the word Yes if the total sales is greater than or equal to $250,000, and No if the amount is below $250,000. Apply automatic formatting to D99, so that Yes appears using Green Fill with Dark Green Text, and No appears using Light Red Fill with Dark Red Text, Please advise
I hope I will get my answer for the desired situation that is: A condition in which we have to assign positive and negative numbers according to time for different time frames. For Example. If I need to mark the time below 9:00 as -2, in between 9:00 to 09:15 as 0 and above 9:15 as -2. And at last I would be able to calculate these points. Could it be possible on MS Excel and Google Sheet?
CAN YOU HELP ME HOW TO SHOW THE FOLLOWING GIVEN BELOW; 8:15AM TO 8:30AM MENTION -1HOUR, 8:31 TO 9:00 MENTION -2HOUR, 9:01 MENTION -4HOURS, 12:00PM MENTION -4HOURS, 3:00PM MENTION -2HOURS, 4:00 PM MENTION -1HOURS ALL THIS IN ONE CELL IS THERE A WAY?
what am I doing wrong here on a scale charging £5 for every 30Kg of weight? =if(E4630.1,"10",if(E46>60.1,"15",if(E46>90.1,"20",if(E46>120.1,"25",if(E46>150.1,"30"))))))
Thank you for this. I forgot how to do this and needed to complete a spreadsheet quickly.
Hi Chester - thanks for this. How would you make the operators dynamic in the formula (i.e. >,). If some of my thresholds need to be greater than a certain value, whilst others less than. Many thanks!
how do you do the if function if it is between two numbers like 1000 and 1400
Thank you for this. Is it possible to change the same column, no column C. Ex: anything in columb B greater the 150 will change to" >150". Thank you kindly
This was very helpful
Hi sir, am watching all ur excel videos it's very helpful for us, pls help to get one formula with if, if A1 is =>2 then it should give 2, if A1 is =>11.25 then it should give max limit of 11.25, meanwhile if the value in between 2 to 11.25 it should give the between value, example if 5 means ans should be 5, only when it goes more than 11.25 it should show only 11.25, pls reply sir
Great tutorials. Very clear
Glad it was helpful!
How to calculate more than or less than by given cell refference?
THANK YOU !
In cell D99 of the August Sales worksheet, use a function to display the word Yes if the total sales is greater than or equal to $250,000, and No if the amount is below $250,000. Apply automatic formatting to D99, so that Yes appears using Green Fill with Dark Green Text, and No appears using Light Red Fill with Dark Red Text, Please advise
Very useful
Hi. thanks for the video. if instead of saying YES or NO how can i get colors in the result?
For example green for yes and red for no
Many years ago I wanted to do that. But gave up in the end. Good luck
Thanks buddy. Helps me alot. 😁
I hope I will get my answer for the desired situation that is:
A condition in which we have to assign positive and negative numbers according to time for different time frames.
For Example.
If I need to mark the time below 9:00 as -2, in between 9:00 to 09:15 as 0 and above 9:15 as -2. And at last I would be able to calculate these points.
Could it be possible on MS Excel and Google Sheet?
Yes it is possible.
Thank you
Can you help me the formula of if the total is =
Thank you..
CAN YOU HELP ME HOW TO SHOW THE FOLLOWING GIVEN BELOW;
8:15AM TO 8:30AM MENTION -1HOUR,
8:31 TO 9:00 MENTION -2HOUR,
9:01 MENTION -4HOURS,
12:00PM MENTION -4HOURS,
3:00PM MENTION -2HOURS,
4:00 PM MENTION -1HOURS ALL THIS IN ONE CELL IS THERE A WAY?
if cell value is 137 and greater than 100 then it should be 37 in excel - Can anyone help me with the excel formula
Accoriding to Excel 10 is greater than 23, "=10>23" returns "TRUE", "=10
what am I doing wrong here on a scale charging £5 for every 30Kg of weight?
=if(E4630.1,"10",if(E46>60.1,"15",if(E46>90.1,"20",if(E46>120.1,"25",if(E46>150.1,"30"))))))
How to ignore blank cells while doing it
CAN SOMEONE ASSIST ME I NEED TO GET THE TIME IFS
I NEED
IF TIMESTAMP < 11:00:00 AM THEN MAKE IT 11:00:00 IF TIMESTAMP >11:00:00 THEN LEAVE IT AS IT IS
share the file sir
Thank you!