Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
if statement | New Users to Excel | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |