#1   Report Post  
Junior Member
 
Posts: 6
Default

Quote:
Originally Posted by sarajmen View Post
thanks buddy formula works perfectly
Hello,
The following question was referred to the same formula
= IF (B21 = $ L $ 17, $ M $ 17, IF (B21 = $ L $ 18, $ M $ 18, E21 * (G21 * (1 + $ H $ 18))))
Can we define if B21 = any cell in column L and if for example L18 ... M18 or L223 .... Enter M223
thanks
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
Can't find project or library (Mid Function) John Viall[_2_] Excel Programming 4 July 21st 07 09:44 PM
function to count project overlap jay d Excel Worksheet Functions 0 August 4th 06 01:42 PM
call a excel function from a vb project Alex281 Excel Programming 2 March 29th 06 05:22 AM
Calling a function in another project from within a cell formula Ellis Horowitz Excel Programming 1 June 25th 04 03:08 PM
Excel lost function pointer in BIG project ? [email protected] Excel Programming 0 June 10th 04 04:47 PM


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