Solved: USING THE "IF" FUNCTION IN A WORD TABLE

[Greg]

I am constructing various Userforms which partly utilise the "IF" function in a table.

One of these is: =IF(D14<=$7,500.00, $92.20, $242.20). In this example there are only two results possible depending on the value of D14.

However, I can't remember how to add in a further variable (in the same equation) to state that if D14 is greater than $25,000.00 then the result is $386.00.

Can anyone refresh my memory on this?

Greg.

[mdmackillop]

Replace the last term with another If function
eg =IF(D14<=$7,500.00, $92.20, if(D14>$25,000.00,$386.00,$242.20))

[fumei]

"Posting Quick Reply - Please Wait"
- VBAX forum

:rotflmao:

[mdmackillop]

Glad you like it Gerry!

[fumei]

Yup...cracked me up. Such...such...such a delicate touch you have. So here I go clicking "Post Quick Reply".

[Greg]

To MD McKillop

Thanks for your help on the IF function. It works perfectly now.