titchestiny
New Member
- Joined
- Nov 3, 2013
- Messages
- 20
[h=2]Hi,
I'm trying to use a formula to select the correct calculation based on the criteria of two different cells. For example;
<tbody>
</tbody>Where B1 and C1 = Exceed, in D1 calculate A1+4, otherwise A1+3.
I've tried using combinations of the IF and AND functions, but neither will except the + symbol. Apologies if my question is particularly dumb. I know I'm missing something - I just can see it!
Any help on this would be greatly appreciated.
Thanks,
Tt
p.s. I'm using Excel 2010[/h]
I'm trying to use a formula to select the correct calculation based on the criteria of two different cells. For example;
<tbody> </tbody> |
<tbody>
</tbody>
I've tried using combinations of the IF and AND functions, but neither will except the + symbol. Apologies if my question is particularly dumb. I know I'm missing something - I just can see it!
Any help on this would be greatly appreciated.
Thanks,
Tt
p.s. I'm using Excel 2010[/h]