|
|
#5
03-22-2020, 09:04 PM
|
|||
|
|||
=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,""), "") 
|
| Tags |
| #value!, adding, if formula |
|
|
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 |
Windows 10 
Office 2010
Threaded Mode