Thread: inverse formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ina ina is offline
external usenet poster
 
Posts: 120
Default inverse formula

Hello guys,

I would like to know if it is possible to do that:

I have this formula:

StrFormula2 = "getCLIENT(""Client"",""" & name & """, ""ROOM"", """ &
currentdate & """, """ & data & """)"

client = evaluate (StrFormula2)



data can be from three different kind. (I cannot access this form as it
is blocked, there is a password)

I have this value client already and I have all the value as name,
currentdate it is easy to find the respective data.


Do you thing do I need to use a case statement?

Ina