MUltiple functions on a same cell

H

harshaputhraya

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
 
J

John

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).
 
Top