Hi
I can't get it right, I've designed a database and designed a Scalextric
race track with all the part numbers in Column A, Qty in Column D, Current
Stock in Column F and to Buy in Column G.

This is what I have tried
=IF(F19=0,"",IF((D19-F19)<=0,"",D19-F19))

This works to a point, it does all the other things I wanted but does not
put the Qty required in Column G, it leaves that cell blank

Example I have
A D F G
C8235 15 blank blank

result should be 15 in Column G as I need 15 of Part C8235 for this track
and I'm showing none in stock in column F so column G should show 15 needed
to buy.

Another example
A D F G
C8205 70 9 61

result should be 61 in Column G

NOTE - if a part is not used result in column G should be blank

I think the first part is redundant. Try:

=IF((D19-F19)<=0,"",D19-F19)

The formula will treat blank or zero in F19 as zero so you'll never evaluate
the other part of the formula.

Regards

Trevor


"Tommo" wrote in message
...
Hi
I can't get it right, I've designed a database and designed a Scalextric
race track with all the part numbers in Column A, Qty in Column D, Current
Stock in Column F and to Buy in Column G.

This is what I have tried
=IF(F19=0,"",IF((D19-F19)<=0,"",D19-F19))

This works to a point, it does all the other things I wanted but does not
put the Qty required in Column G, it leaves that cell blank

Example I have
A D F G
C8235 15 blank blank

result should be 15 in Column G as I need 15 of Part C8235 for this track
and I'm showing none in stock in column F so column G should show 15
needed
to buy.

Another example
A D F G
C8205 70 9 61

result should be 61 in Column G

NOTE - if a part is not used result in column G should be blank

Hi Tommo,

If I understand you correctly, it is just the first bit
of your formula that is wrong.
Instead of =IF(F19=0........
Shouldn't it be =IF(D19=0........

HTH
Martin


"Tommo" wrote in message
...
Hi
I can't get it right, I've designed a database and designed a Scalextric
race track with all the part numbers in Column A, Qty in Column D, Current
Stock in Column F and to Buy in Column G.

This is what I have tried
=IF(F19=0,"",IF((D19-F19)<=0,"",D19-F19))

This works to a point, it does all the other things I wanted but does not
put the Qty required in Column G, it leaves that cell blank

Example I have
A D F G
C8235 15 blank blank

result should be 15 in Column G as I need 15 of Part C8235 for this track
and I'm showing none in stock in column F so column G should show 15
needed
to buy.

Another example
A D F G
C8205 70 9 61

result should be 61 in Column G

NOTE - if a part is not used result in column G should be blank

Maybe this:
=IF(A19="","",IF((D19-F19)<=0,"",D19-F19))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tommo" wrote:
Hi
I can't get it right, I've designed a database and designed a Scalextric
race track with all the part numbers in Column A, Qty in Column D, Current
Stock in Column F and to Buy in Column G.

This is what I have tried
=IF(F19=0,"",IF((D19-F19)<=0,"",D19-F19))

This works to a point, it does all the other things I wanted but does not
put the Qty required in Column G, it leaves that cell blank

Example I have
A D F G
C8235 15 blank blank

result should be 15 in Column G as I need 15 of Part C8235 for this track
and I'm showing none in stock in column F so column G should show 15 needed
to buy.

Another example
A D F G
C8205 70 9 61

result should be 61 in Column G

NOTE - if a part is not used result in column G should be blank