another if/then formula for Word 2000

K

kimatdsc

Member
Joined
Jan 7, 2004
Messages
5
I have another if/then formula that I need help with.

The logistics are if the value of cell A1= given text, then the value of the cell I am entering the formula in is the .000 number after "then." Can anyone help me build this formula for Word 2000? Thank you!! - Kim

If A1=HMH_ER, then .065
If A1=HMH_URG, then .065
If A1=VMC_ER, then .07
If A1=Polyclinic, then .07
If A1=Doctors, then .07
If A1=VMC_Clin, then .075
If A1=VMC_Hosp, then .075
If A1=VMC_Fam, then .07
If A1=VMC_Spec, then .075
If A1=PeninCom, then .07
If A1=HMH_Hosp, then .07
If A1=Virginia Mason, then .07
 
here is a short version but hopefully you will get the idea and ad all the rest of the ifs

=IF(OR(A1="HMH_ER",A1 = "HMH_URG"), .065, IF(OR(A1 = "VMC_ER",
A1 = "Policlinic),.7, IF(etc...))
 
wont take quotes... if/then statement in Word 2000 table

Thanks so much for your help!

I tried the formula you described and had a syntax error, so I simplified the formula trying to figure out where the problem might be.

I used the simple formula

=IF(A1="HMH_ER",.065,0)

and I get a syntax error

but if I used the formula

=IF(A1=1,.065,0)

then it works fine (except that it rounds the .065 and I need it to be an exact number, you might be able to help me with that, too..?)

I tried also

=IF(A1=1,"TIME",0)

and I still get a syntax error

It seems that the quotes are not working correctly as defining text..?? thats all I can figure out from my troubleshooting.

any help would be greatly appreciated, thanks! - Kimberly
 
I used the first formula =IF(A1="HMH_ER",.065,0)
and I didnt get the error.

Could be in your format of the cell. And for the round up, it sounds like the needs to be formatted. Goto format cell then you can select the decimal point length. It is usually defaulted to 2 places and needs to be set to 3 places
 
Excel versus Word using if/then formula

Im finally getting back to this project!

I tried that formula you are talking about in Excel and it works great, and Excel does have "format|cell" where I can change how many decimal places are used, but I am trying to write the formula in a Word 2000 table, so I am wondering if the formula

=IF(A1="HMH_ER",.065,0)

worked in a Word 2000 table for you, or if you were trying it in Excel?

Thanks so much for your help, I really appreciate it!

- Kim
 
Back
Top