=IF Formula – The statement value is not stored as a number.
Hi,
I am pretty amateur with excel and trying my best with googling all possible solutions but i am coming up short.
I am using formulas to format that if an employee works 6 days then they are given a £90 bonus, and if they work one day they are given a £50 bonus.
I have an =IF formal in place that if the selected cell says 6 days it will input £90 into the cell I require. And vice versa. That £90 is then needed to be added up in a =SUM formula to give me a sum of two cells. However as the £90 not a value is will not add up in the =SUM formula.
Is there another way around this?
Hi, I am pretty amateur with excel and trying my best with googling all possible solutions but i am coming up short. I am using formulas to format that if an employee works 6 days then they are given a £90 bonus, and if they work one day they are given a £50 bonus. I have an =IF formal in place that if the selected cell says 6 days it will input £90 into the cell I require. And vice versa. That £90 is then needed to be added up in a =SUM formula to give me a sum of two cells. However as the £90 not a value is will not add up in the =SUM formula. Is there another way around this? Read More