Excel multiple IF statement issue

Anj12321

New Member
Joined
Mar 20, 2018
Messages
1
Trying to amend the formula for the below

Columns - ABCDEFGHIJK

Date 01/06/2018

00000100
00000100
-4-3-2-10123
Jan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18

<colgroup><col span="8"></colgroup><tbody>
</tbody>

The date is 01/06/2018 so i have a formula with '1' showing in the top row which works fine in the June column. But the second row i want to show the 1 below the first row and then a '2' in the next cell (highlighted in red) and onwards with '3' in Aug and so on - i have used =IF(G2=0,0,IF(G2=1,1,IF(F2=1,F2+1,0))) but doesnt seem to work. Please can you assist, will very much appreciate it.

Thanks
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Forum statistics

Threads
1,214,830
Messages
6,121,834
Members
449,051
Latest member
excelquestion515

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?

Disable AdBlock

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
Back
Top