I have been trying to create an IF formula to solve the following problem bu without success:
I want to display the different monetary values of a range of medical tariff codes, that a user would enter.
So, tariff code 84200 has a value of R200 (ZAR)
Tariff code 84201 has a value of R225.
Tarrif code 84202, a value of R250 and so on.
The money value increment is R25 for the codes starting at R200 for 84200 through to 84211.
What is the structure of the formula to display the Rand value when a code is entered?
Thanks
Hennie
Bookmarks