MUltiple functions on a same cell
 

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

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