View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John
 
Posts: n/a
Default MUltiple functions on a same cell

Yes, If you would like to lookup a value using vlookup and then round it.
You would use something like =roundup(vlookup(A1,B3:C7,2,false),2) ... This
would round up the vlookup of the value in A1 (rounding the coresponding
value found in column C of A1 found in column B).



Hi,

Does Excel allow to use multiple formulas on the same cell??
For example, i want to use VLOOKUP and ROUNDUP on the same cell. Is
this possible?
If you have any solution, please share it with me.

Appreciate your time and help:)

Harsha


--
harshaputhraya
------------------------------------------------------------------------
harshaputhraya's Profile: http://www.excelforum.com/member.php...o&userid=33225
View this thread: http://www.excelforum.com/showthread...hreadid=539756