LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
SteveT
 
Posts: n/a
Default Validation depends on cell value

if cell a1 = b1/2 user should choose if 1st half of order or 2nd half.
The answer will post as a result in c1. In other words if a1 = 25 and b1 =
50 the user should choose if c1 equals 1 or 26 (1st or 2nd part of total
units in cell B1)

any help greatly appreciated.

Steven
 
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
List, Data Validation, unlocked cell, protected sheet..... Kane New Users to Excel 6 July 16th 12 09:11 AM
Data Validation Window? Ken Excel Discussion (Misc queries) 1 January 11th 05 10:48 PM
how to add two data validation lists to a single cell? Mike Peter Excel Worksheet Functions 1 December 8th 04 08:22 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
Cell Validation. Mark Solesbury Excel Worksheet Functions 1 November 2nd 04 10:31 AM


All times are GMT +1. The time now is 04:04 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"