Make a cell value dependent on another cell's values,

I'm new to excel and i'm trying to creat a basic work sheet to help with my daily tasks.

I need a formulae that will allow me to perform the following

If C4 = 1 then C14 = 7.5, If C4 = 2 then C14 = 10 If C4 = 3 then C14 = 12

Thanks

Hi,
You can do this with

Formula:

Please Login or Register  to view this content.

or by using vlookup.

BR

Hi,and welcome to the forum.

Unfortunately your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

Since you are new here I'll change the title on this occasion but please note for future reference

You don't say what the result should be if C4 is none of the three values. I'll assume a blank therefore.

In C14

=IF(C4=1,7.5,IF(C4=2,10,IF(C4=3,12,"")))

@Miroslav. Also please note the rule and the requirement for a change to be made before a response is due.