Thanks buddy. Helps me alot. 😁

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!

THANK YOU !

Very useful

Thank you for this. I forgot how to do this and needed to complete a spreadsheet quickly.

Thank you

This was very helpful

Great tutorials. Very clear

how do you do the if function if it is between two numbers like 1000 and 1400

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

How to calculate more than or less than by given cell refference?

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

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?

Can you help me the formula of if the total is =

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"))))))

share the file sir

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