Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Multiple IF formulas that are not nested still returning #VALUE!
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 03-24-2020, 01:23 AM
p45cal's Avatar
p45cal p45cal is offline Multiple IF formulas that are not nested still returning #VALUE! Windows 10 Multiple IF formulas that are not nested still returning #VALUE! Office 2019
Expert
  
Join Date: Apr 2014
Posts: 962
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Marcia is right; simplest is:
=SUMPRODUCT(A2:A10,B2:B10)
Reply With Quote
  #2  
Old 03-25-2020, 10:53 AM
dhouston1000 dhouston1000 is offline Multiple IF formulas that are not nested still returning #VALUE! Windows 10 Multiple IF formulas that are not nested still returning #VALUE! Office 2010
Novice
Multiple IF formulas that are not nested still returning #VALUE! 		 
Join Date: Jan 2020
Posts: 14
dhouston1000 is on a distinguished road
Default
It worked and without all of those IF's.


Thanks,
David
Reply With Quote
Reply

Tags
#value!, adding, if formula

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word moves up multiple pages after returning to document falcios Word 4 08-23-2019 12:13 PM
VBA for ContentControl returning multiple lines of text SuziBaz Word VBA 5 04-13-2018 05:11 PM
Adding IF in nested formulas caz46 Excel 5 03-30-2017 03:38 AM
Returning value based on multiple crtiteria stockers Excel 3 03-06-2017 05:05 PM
copying nested if over multiple rows where one value stays fixed charles_cat Excel 1 01-23-2015 01:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:43 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft