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!
|