I need to have a formula where a cell is multiplied depending on a Y or N in another cell. If Y *2, if N *1. I can make a formula to do one calculation but not work out how to do the full thing’
So far ive come up with:
e.g. formula in C3 would be =IF((B3=“Y”),A32)
that seems to work,but i cannot make it do the “N”),A31 part.
Any help greatly recieved.