I want to make a cell choose the function it carries out
For example;
If cell a1 = yes cell f4 = f1+f2
if cell a1 = no cell f4= f1+f3
Can anyone help i am new to excel
Thanks xx
I want to make a cell choose the function it carries out
For example;
If cell a1 = yes cell f4 = f1+f2
if cell a1 = no cell f4= f1+f3
Can anyone help i am new to excel
Thanks xx
Enter in F4-----> =If(A1="Yes",F1+F2,If(A1="No",F1+F3,""))
Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Hi emily1 and welcome to the forum,
Put the following in F4
=If(A1="Yes",F1+F2,If(A1="No",F1+F3,""))
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks