Thread: Multiple IF formulas that are not nested still returning #VALUE!
View Single Post
 
Old 03-22-2020, 10:35 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
Actually you do not need the (B$2:B$10>0) to get the correct result.
Reply With Quote