software

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: www.excelforum.com/member.php...oamp;userid=33225
View this thread: www.excelforum.com/showthread...hreadid=539756Yes, 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).gt;
gt; Hi,
gt;
gt; Does Excel allow to use multiple formulas on the same cell??
gt; For example, i want to use VLOOKUP and ROUNDUP on the same cell. Is
gt; this possible?
gt; If you have any solution, please share it with me.
gt;
gt; Appreciate your time and help
gt;
gt; Harsha
gt;
gt;
gt; --
gt; harshaputhraya
gt; ------------------------------------------------------------------------
gt; harshaputhraya's Profile: www.excelforum.com/member.php...oamp;userid=33225
gt; View this thread: www.excelforum.com/showthread...hreadid=539756
gt;
gt;