Remember Me?

#1
June 9th 05, 12:54 PM
 Graeme Crook Posts: n/a
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
June 9th 05, 11:31 PM
 Posts: n/a

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 flycast Excel Discussion (Misc queries) 4 May 26th 05 04:26 AM jackle Excel Worksheet Functions 0 May 25th 05 02:10 PM rob1234 Excel Worksheet Functions 1 May 12th 05 06:18 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:03 AM.