Get instant live Excel expert help with IF AND Functions

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

hi need to modify the sheet and organize the data
Solved by V. S. in 26 mins
Help me to get the sum of each payment methods and order status.
Solved by G. D. in 25 mins
eed if formula If sold apple and sold orange and sold banana are more than target apple and orange and respectively then ach = (A+B+C)*G. if only one fruit of the them is more than target then ach= sold fruit*G if only sold orange are more similary for if only two sold fruit are above target
Solved by F. E. in 23 mins
Ip adresses and ordering them as i want...accept it.....
Solved by T. S. in 25 mins
trying to copy over a name and primary date from one row of sheet 1 to sheet 2 if it meets the following criteria: a secondary date field located on sheet 1 is left blank for 15 days or more beyond the primary date field. Sheet 2 is the list of everyone who still does not have the secondary date field fulfilled, but the names and original dates only populate if the secondary date field is not fulfilled after 15 days from the primary date.
Solved by F. B. in 17 mins
Need help with formula if and or.................
Solved by T. H. in 25 mins
I am calculating the time between an order being placed and order being delivered. I used =TEXT($R$2-$E$2,"h:mm:ss") to get this. I'm now trying to use an IF Function to say that if the time is <45 mins, say it's "fast" else, "slow". I have tried an if function text: =if((TEXT($R$2-$E$2,"h:mm:ss"))<time(0,45,00),"fast","slow") but everything returns as slow, which isn't correct. Can you help?
Solved by X. U. in 23 mins
I need help tying out numbers between orders and revenue and orders and revenue summaries
Solved by X. U. in 25 mins
I need help tying out numbers between orders and revenue and orders and revenue summaries using a sumifs formula to equal
Solved by G. B. in 24 mins
I need assistance with the IF ((AND or IF((OR logical statements. I have a value in the B1:B----, so the if(B23="","", works so that nothing gets past in the Tier REached Table if nothing is listed in the B23. However i want to run a formula that can exicute that command as well as leave the rest of the field empty if AA23="","" in AM54.
Solved by I. Q. in 26 mins