LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Thu, 12 May 2005 13:30:48 -0700, "David F"
wrote:

Many thanks. It did work.
Interestingly, I did try first =IF(..., but because it depends on another
cell where I had an 'IF(...' (w/o the '=') it gave me an #VALUE! which I did
not trace so I gave up on the '=IF(...' too early...
FYI, I did not need to reenter the entire statement. It is enough if I just
add the '='.

Thsnks again,
David


I'm glad you got it working.

Yes there are some shortcuts that will sometimes work compared with the
instructions I posted.

Best wishes,


--ron
 
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
Fundamental problem with IF statement David F Excel Worksheet Functions 4 May 12th 05 09:34 PM
Formula Problem - If Statement Margie Excel Worksheet Functions 4 April 29th 05 10:07 PM
Row Autofit problem Excel 2003 Matthias Klaey Excel Discussion (Misc queries) 0 January 19th 05 05:33 PM
IF statement problem simon Excel Worksheet Functions 1 December 30th 04 10:59 AM
IF statement problem Kalabalana Excel Worksheet Functions 4 November 24th 04 08:37 PM


All times are GMT +1. The time now is 07:02 AM.

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"