LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 44
Default pre determine value

Can you look at the example below and provide me with the solution? Would
appreciate your help in this mater.

EXAMPLE

A B C D E F
======================================
1 1000 ANY VALUE 5 16/05 10 =IF(A10,
1000-10, "")
2 ...........................
3 ...............................
4 .................................................. ...
5 .................................................. ..................

HINTS I WANT ALLOCATE VALUE TO B1, C1, D1 & E1 IS EQUAL TO 10
ITS MEAN IF B1 or C1 or D1 or E1 is grater then 0 (zero) then formula will
work but i can work only with one cell like above how can extand this formule
in same cell i.e. F1

Regards
Malik Nadeem
0092 300 2556512

 
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
How to determine the value? Eric Excel Discussion (Misc queries) 7 August 16th 07 01:42 AM
How to determine the value? Eric Excel Discussion (Misc queries) 1 July 24th 07 07:14 AM
How to determine the value? Eric Excel Worksheet Functions 1 February 13th 07 04:17 AM
How to determine the value? Eric Excel Discussion (Misc queries) 0 February 13th 07 03:26 AM
How to Determine 1st, 2nd & 3rd for a PWD Pete n PWD Land Excel Discussion (Misc queries) 3 February 17th 05 09:25 PM


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