# Help with a formula please

#### DAVE H

##### New Member
I have 3 cells containing values. I need a formula that would give the result of combining these values according to the following four possiblities. The result wouild go into cell C23.
If cell C17< cell C13 and cell C6<1 then cell C23=Cell C6 *1000
If cell C17< cell C13 and cell C6>=1 then cell C23=cell C6
If cell C17>=cell C13 and cell C6<1 then cell C23=cell C6 *500
If cell C17>= cell C13 and cell C6>=1 then cell C23=cell C6
I hope that you can understand what I am trying to do.
I have tried to do it using and & if operator but can't seem to get the right results.

Yours hopefully DAVE H

Last edited:

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
=IF(AND(C17<C13,C6<1),C6*1000,IF(AND(C17<C13,C6>=1),C6,IF(AND(C17>=C13,C6<1),C6*500,IF(AND(C17>=C13,C6>1),C6,"Something Else"))))

Hi and welcome to the board!!
Code:
``=IF((C17< C13)*(C6<1),C6*1000,IF((C17<C13)*(C6>=1),C6,IF((C17>=C13)*(C6<1),C6*500,C6)))``

lenze

Last edited:
I think this is what you asked

Code:
``=IF(AND(C17 < C13,C6 < 1),C6*1000,IF(AND(C17 < C13,C6>=1),C6,IF(AND(C17>=C13,C6 < 1),C6*500,0)))``

Last edited:
Thanks to all who replied to my post. With all your help I now have solved my problem. Also I have a little more understanding of how "IF" & "AND" work in a formula.
This was my first post as I have recently joined the forum. I was amazed at the quality & the speed of your responses.

Many thanks again Dave H.

Replies
11
Views
469
Replies
1
Views
135
Replies
12
Views
486
Replies
6
Views
277
Replies
3
Views
64

1,203,461
Messages
6,055,559
Members
444,798
Latest member
PAO1609

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back