S
Smithers
Can Word perform if functions like Excel?
I have a table and in cell C2 I have the user enter the number of months
at/above goal. Then in D2, I want to calculate the answer. In excel I used
=IF(C2>3,IF(C2>6, IF(C2>9, IF(C2>10, IF(C2>10.5,5),4),3),2),1) to give me the
correct information. Is this possible in word?
I have a table and in cell C2 I have the user enter the number of months
at/above goal. Then in D2, I want to calculate the answer. In excel I used
=IF(C2>3,IF(C2>6, IF(C2>9, IF(C2>10, IF(C2>10.5,5),4),3),2),1) to give me the
correct information. Is this possible in word?