Say I have the following function:
=(B19*B18)+(C19*C18)+(D19*D18)+(E19*E18)+(F19*F18)
How can I add an if statement to this if i only want the values calculated that have a value entered?
Example: If C19, D19, and E19 have no values in them, its blank, how can I have the above function "ignore" them? (So in a way, its only calculating =(B19*B18)+(F19*F18) if those listed above are blank).
Can I add an IF on each (...)? How would that look?
Thanks in advance!
=(B19*B18)+(C19*C18)+(D19*D18)+(E19*E18)+(F19*F18)
How can I add an if statement to this if i only want the values calculated that have a value entered?
Example: If C19, D19, and E19 have no values in them, its blank, how can I have the above function "ignore" them? (So in a way, its only calculating =(B19*B18)+(F19*F18) if those listed above are blank).
Can I add an IF on each (...)? How would that look?
Thanks in advance!