I hope someone here can help with this. I am trying to create formula which will perform one of two different calculations depending on the value of a yes/no cell.
I want to create a formula that, if the condition is met (namely that the referenced cell has a "yes") then the following formula will be performed: the quotient of two absolute cells is subtracted from D3 and then the result is multipled by .235, otherwise if the condition is not met then the result is instead multiplied by 0.25.
What I have now that doesn't seem to work:
=IF(E56="Yes",(D56-$B$3/$A$56)*0.235,(D56-$B$3/$A$56)*.25)
Further information is that all referenced cells contain a function and A56 contains the Count function.
Bookmarks