IF formula adds all the values in a range that meet the specified criteria
Live Example Here:
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Again, thank you so so so so much!!! For this formula, it has also been months of trying to figure out how to do it, with lots of help from other coworkers who use excel quite a bit, but we were never able to get the formulas right and you explained it so well, I tried following along, and eventually the formula works!! YAY!!! Thank you!!!!!!!!
Hello Sir
I'm getting this message for a formula I'm writing
This formula uses more levels of nesting than you can use in the current file format
How can i use this formula, tell me please
=IF(C10=0,"0.00",IF(C10=1,"1.08",IF(C10=2,"1.05",IF(C10=3,"1.03",IF(C10=4,"1.04",IF(C10=5,"0.94",IF(C10=6,"0.90",IF(C10=7,"0.84",
IF(C10=8,"0.75",IF(C10=9,"0.70",IF(C10=10,"0.65",IF(C10=11,"0.63",IF(C10=12,"0.57",IF(C10=13,"0.53",IF(C10>=14,"0.50")))))))))))))))
what if i don't want it to return "0" but instead i want it to leave it as a blank space?