Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 20
Default If,Then Statement

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)
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 793
Default If,Then Statement

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...



"Lizz45ie" wrote:

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)

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF statement inside a SUMIF statement.... or alternative method Sungibungi Excel Worksheet Functions 3 December 4th 09 06:22 PM
Reconcile Bank statement & Credit card statement & accounting data Bklynhyc Excel Worksheet Functions 0 October 7th 09 09:07 PM
Embedding an OR statement in an IF statement efficiently Chatnoir11 Excel Discussion (Misc queries) 4 February 2nd 09 08:12 PM
Sum if statement with a left statement Eric D Excel Discussion (Misc queries) 4 July 23rd 08 05:31 PM
appending and IF statement to an existing IF statement spence Excel Worksheet Functions 1 February 28th 06 11:00 PM


All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"