[Solved] To many nested IF's?? Please Help.
I'm having trouble added one final function to this formula:
[=IF(COUNT(K8,M8)=2,"Call Made",IF(I8>25,"Call Now","Not Ready"))]
I would like to add a function where if cell G8 is blank then J8 will be blank as well. I'm already in a little over my head and just received some help adding the IFCOUNT function.
I've attached the spreadsheet for reference.
Again, all help is wanted and greatly appreciated!
Last edited by m.arce; 06-30-2011 at 03:00 PM.
m.arce,
Give this a try:
=IF(G8="","",IF(COUNT(K8,M8)=2,"Call Made",IF(I8>25,"Call Now","Not Ready")))
Hope that helps,
~tigeravatar
Wow! Thank you! I would have spent hours trying to figure that out with minimal, if any, success. Thank you for being an Excel Guru...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks