If,Then Statement

  • Thread starter Thread starter Lizz45ie
  • Start date Start date
L

Lizz45ie

How do I write a If statement that compares the next row and then divide a
number that is in another column. Here is an example of my data:

sales order actual hour Avg # of hrs
660000001234 40.0
660000001234
660000001234

Here is my formula: =IF(A50 = A51,F50/2, F50)
 
You have written the right formula yourself...
=IF(A50 = A51,F50/2, F50)
This will check wheterh A50 is equal to A51 and divide F50 by 2 if they are
otherwise leave F50 the same...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup with part match 5
IF statements 3
SUMIF Alternative? 2
Fill handle formula 9
Help with logical function 3
Repeating 'SUMIF' formula for entire column 4
SUMIF Alternative? 1
Help with IF function 3

Back
Top