If function

[mechpm]

Dear Sirs or Mama’s


I need an =if ( type thing that will return a blank cell if condition is negative

Example: I have C3+G32 in cell D32. however, if cell H32 is negative I need cell D32 to do nothing and return 0 or a blank cell so that it will not be calculated in column D.


Thx.

R W

[Ivan F Moala]

On 2002-05-18 06:23, mechpm wrote:
Dear Sirs or Mama’s


I need an =if ( type thing that will return a blank cell if condition is negative

Example: I have C3+G32 in cell D32. however, if cell H32 is negative I need cell D32 to do nothing and return 0 or a blank cell so that it will not be calculated in column D.


Thx.

R W

Hi R W
For 0
=IF(H32<0,0,C3+G32)

Or
For ""
=IF(H32<0,"",C3+G32)

[sen_edp]

Hi RW

Microsoft Excel - HtmlMaker.xls
File(F) Edit(E) View(V) Insert(I) Tool(T) Data(D) Window(W) Help(H)
B2		=
	B	C	D	E	F	G	H	I
2
3		100
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32			formula ->	:alert('0')>=IF(H32<0,0,G32+C3)		120	-100
33
Sheet1

You can see the value of cells only click each above hyperlinks


Hope that helps

[sen_edp]

Hello Ivan

How are you ?

We met again - Nice !!!

I installed the addin colo send me (htmlmaker) and it is not working well, is there any update ?

[DeLaMartre]

Ivan & Andreas,

I have a perhaps naive question: What is the purpose of the last ">" in the recommended formulas? The formulas are quite simple, except for that element, (or maybe I'm just simple-minded at 6:30 on Saturday morning...)
Thanks!
-Bob in California

[ This Message was edited by: DeLaMartre on 2002-05-18 06:39 ]

[Ivan F Moala]

On 2002-05-18 06:33, sen_edp wrote:
Hello Ivan

How are you ?

We met again - Nice !!!

I installed the addin colo send me (htmlmaker) and it is not working well, is there any update ?

Hello again.
Yes there is an update, I was actually going
to suggest an update when I viewd your post.

Email Colo or I can send you one...although
it will not be the finalised version as Colo
and I are working on a few other things
seperately and then combining latter.

[sen_edp]

hello Bob

I thing you mean the < symbol than means

less

[Chris Davison]

Bob,

you don't mean "formula ->" do you ?

I thik it's an "arrow" not part of the formula itself....

[sen_edp]

Ok Ivan thanks

I 'll email Colo

I got to go now - thanks again

[sen_edp]

Hello Chris

Yes it is an arrow indeed , i just put it there to show it better , but it seems that
it confused a liitle bit.