i have extremely basic skills when it comes to excel
i have 2 cells
H4 , H5
i want H5 to have a figure depending on what H4 is
this is what i will put in H5
e.g
=IF(H4=0,0) OR -- so if H4 is 0 put 0 in H5
=IF(H4=1,18) OR -- if H4 is 1 put 18 in H5
=IF(H4=2,23) OR -- If H4 is 2 put 23 in H5
=IF(H4=3,30) -- If H4 is 3 put 30 in H5
These formulas work individually, however i need them all into 1 formula and no matter what i try i just get errors
can anyone help
Many Thanks
Bookmarks