Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 9th 05, 12:54 PM
Graeme Crook
 
Posts: n/a
Default Wildcards in Functions


I am aware that Wildcards can't be used in IF statements, but can't
think of a way round this problem, and would appreciate some help.

The following function works as I want it to:
=SUM(-H25-IF(G25=-0.25,ROUNDDOWN(G25,0),G25))

However, I would like to change the 0.25 to *.25 as any number could
end in the .25, and if it does I want to round it down for the purposes
of the calculation. The only question is how can this be done, when
wildcards can't be used?!

Thanks,
Graeme


--
Graeme Crook

  #2   Report Post  
Old June 9th 05, 11:31 PM
 
Posts: n/a
Default

Graeme -

IF(TRUNC(ABS(G25))-ABS(G25)=-0.25,...

Good Luck, Hash (you sure it's minus .025 that you want?)



In article ,
Graeme Crook wrote:

I am aware that Wildcards can't be used in IF statements, but can't
think of a way round this problem, and would appreciate some help.

The following function works as I want it to:
=SUM(-H25-IF(G25=-0.25,ROUNDDOWN(G25,0),G25))

However, I would like to change the 0.25 to *.25 as any number could
end in the .25, and if it does I want to round it down for the purposes
of the calculation. The only question is how can this be done, when
wildcards can't be used?!

Thanks,
Graeme



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
Default User Defined Functions - How? flycast Excel Discussion (Misc queries) 4 May 26th 05 04:26 AM
PASTE DOWN FUNCTIONS jackle Excel Worksheet Functions 0 May 25th 05 02:10 PM
remote functions rob1234 Excel Worksheet Functions 1 May 12th 05 06:18 PM
3 questions about automated c++ com add-in worksheet functions gert Excel Worksheet Functions 0 March 10th 05 09:57 AM
# of Functions per cell SUB-ZERO Excel Worksheet Functions 3 January 23rd 05 10:35 PM


All times are GMT +1. The time now is 11:03 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017