Try this in say F28:
=IF(AND(C28="",D28="",E28<""),E28/12,IF(AND(C28="",D28<"",E28=""),D28/3,IF(AND(C28<"",D28="",E28=""),C28,"Input
only one value in either C28, D28 or E28. In C28 for monthly payments, in D28
for quarterly payments, in E28 for annual payments")))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rich" wrote:
Ok maybe better description is needed... If I enter 100 in cell C28 then the
formula C28/1 will perform(Answer 100). If I enter a number, say 300, in D28
then D28/3 will perform(Answer 100) or if I enter a number, say 1000, in E28
then E28/12 will perform (answer 83.333)