Hello and Greetings to all,
I am a new member here and would like to seek the help to get my formula correct to work on an inventory file:
there are three counts, first count, second count and Third count for the same item. But would like to to get the count as per below:
If second count and third count are Blank or Zero: need to get the figure of first count as the final count.
If there is a value in second count and third count: need to get the figure of second count as the final count
If there is a value in first count and third count: need to get the figure of third count as the final value. I have create a formula as per below and its fine with the first and second count. But its not taking care of the third count and give as false if there is a value in Third count:
=IF(AND(G21="",F21),IF(H21="",F21),IF(G21>=0,G21 or IF(H21>0, H21)))
Appreciate your support on this. Thank you. Thomas Mathew
Bookmarks