if if if

[cream puff]

I have a spread sheet that has a data table attached to it.

I have three columns that indicate three different parts of the data table.

I would like to write a formula that says if something like

if 3a is marked then this value goes into this cell.

I know this is something simple but I just can't get my mind around it.

Thanks you for your help.
Cream Puff

[davesexcel]

Hi,
Can you elaborate

if 3a is marked then this value goes into this cell.

What does that mean exactly

[Maxxscape]

If I am reading you correctly, I did something like this a few hours ago...

=IF(K6,A6,"")

If K6 is true put the value of A6 in this cell, if not leave it blank...

This one pulls info from another worksheet

=IF(AND(A2<>"",'Payroll & Expenses'!J10),37.5,IF(A2 > "",75,""))

If A2 has something in it and the check box on the other worksheet, in J10 is checked then enter 37.5 in this block... else if there is something in A2 then put 75 in this block... Notice I tried it with <> and > when checking the value of A2 just to see if it worked...

There might be an easier way to do it but I am learning as I go...

I need to take this a step further tho... In this case, our payroll will only payout 75 dollars for a hotel room... 37.50 if the room is double occupancy... If the hotel cost was less then I need to be able to reflect that...

Still working on it... I'm sure it's fairly simple...

[mudraker]

cream puff

Please read forum rules (rule 1) & use suitable thread titles

A thread with the rules is available at the top of each forum or see link below for rules