I need assistance as to how to create a formula to get results when the source cell already has a formula that I am depending on to check if the figures are present or not in order for my calculation to work correctly? Please see the below details as an example.
Cell A1 has "If(And(" formula to bring results when conditions in other cells are met. Cell A2 has a fixed cost of $1. I am trying to create a formula in Cell A3 which should only add value from Cell A2 ($1) if Cell A1 is showing figures? So my formula in A3 that I was trying is "If(A1>0, A2,0)". In this example even though Cell A1 is not showing any figures but I still get A2 figures in A3 when I should expect to see 0? Can you help as to how I should create a formula when the source cell also has a formula but does not show any figures in the cell? I hope that I have not made this question too confusing, but in short, what I am asking is that how the formula should be created when the source cell that I am looking at already contains formula. Thank you in advance for your assistance.
Cell A1 has "If(And(" formula to bring results when conditions in other cells are met. Cell A2 has a fixed cost of $1. I am trying to create a formula in Cell A3 which should only add value from Cell A2 ($1) if Cell A1 is showing figures? So my formula in A3 that I was trying is "If(A1>0, A2,0)". In this example even though Cell A1 is not showing any figures but I still get A2 figures in A3 when I should expect to see 0? Can you help as to how I should create a formula when the source cell also has a formula but does not show any figures in the cell? I hope that I have not made this question too confusing, but in short, what I am asking is that how the formula should be created when the source cell that I am looking at already contains formula. Thank you in advance for your assistance.