Remember Me?

#1
June 10th 05, 10:17 AM
 Graeme Crook Posts: n/a
Wildcards in Functions

#2
June 10th 05, 10:42 PM
 [email protected] Posts: n/a

Graeme -

You're welcome, of course. I should have pointed out that
without it.

....best, Hash

In article ,
Graeme Crook wrote:

Hash - Thanks for this. It is a negative that I was after, and it seems
to be working fine.

Graeme

Wrote:
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-

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Graeme Crook Excel Worksheet Functions 1 June 9th 05 11:31 PM flycast Excel Discussion (Misc queries) 4 May 26th 05 04:26 AM jackle Excel Worksheet Functions 0 May 25th 05 02:10 PM gert Excel Worksheet Functions 0 March 10th 05 09:57 AM SUB-ZERO Excel Worksheet Functions 3 January 23rd 05 10:35 PM

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