Microsoft Office Forums - View Single Post - Multiple IF formulas that are not nested still returning #VALUE!

Thread: Multiple IF formulas that are not nested still returning #VALUE!

View Single Post

Old

03-22-2020, 09:04 PM

dhouston1000 dhouston1000 is offline

dhouston1000 is offline

dhouston1000 uses Windows 10

Windows 10 dhouston1000 uses Office 2010

dhouston1000 uses Office 2010

Office 2010

Novice

The original poster

Join Date: Jan 2020

Posts: 14

dhouston1000 is on a distinguished road

Default

=iferror(if(b2>0,b2*a2,"")
+if(b3>0,b3*a3,"")
+if(b4>0,b4*a4,"")
+if(b5>0,b5*a5,"")
+if(b6>0,b6*a6,"")
+if(b7>0,b7*a7,"")
+if(b8>0,b8*a8,"")
+if(b9>0,b9*a9,"")
+if(b10>0,b10*a10,""), "")

Reply With Quote