How do I write the proper Formula for the following?
 

Here are the paramaters I am trying to write a funtion for using Excel 2007:

If C3=0, then final value will be C58/2
If C58=0, then final value will be C3*2
If C3 and C58 both do not equal 0, then the final value will be [(C3*2)+C58]/3

I appreciate the help!

How do I write the proper Formula for the following?
 

Try this formula:

=IF(C3<0,IF(C58<0,(((C3*2)+C58)/3),C3*2),C58/2)


Regards,
Per

"Brady D" skrev i meddelelsen
...
Here are the paramaters I am trying to write a funtion for using Excel
2007:

If C3=0, then final value will be C58/2
If C58=0, then final value will be C3*2
If C3 and C58 both do not equal 0, then the final value will be
[(C3*2)+C58]/3

I appreciate the help!