User input box in a IF function without macro?

[tony0710]

Hi All

Not sure if this is possible:

I would like to write an IF function, without the use of macro, in which a user input box pops up.

For example:

In A2 = Vin or Vnil or Vout, then in A3, i'd like an 3 combined IF functions:

IF(A2)="Vin", ((A2*7)/47))
IF(A2)="Vnil", "-"
IF(A2)="Vout",(Pop-up box to pop up and ask user to input VAT figure) - the figure then to be put into A3

I'm sure that I can write the combined IF functions - but just need to know if a pop up user input box can be used? And if so, how to write that.

If this is impossible then I suppose that VBA macro will have to be written.

Hope someone can help.

Tony

[mohitspamz]

In Excel a Cell can either be used to write a formula or manually enter data, not both.

But you could try the data validation route... whereby you can force the operator to enter "-" when A3 is Vnil and calculate and enter the value of A2*7/47 if A2 is Vin or otherwise free cell to enter any value when A2 is Vout

Go to Data>Validation>Custom and enter ur validation formula

Hope that helps

Regards
Mohit

PS: A2 is Vin, Vout or Vnil, then u cant multiply A2 by 7 and divide it by 47

[tony0710]

Thanks for reply - will give that a go today - and see what happens.

Yes you are right - the cell to be multiplied and divided is A1 - not A2 as you pointed out - sorry for the confusion