formula if

I am new to excel. I am trying to categorise numbers of employees in groups. In one column I have numer of employees and other has nothing in it and I am writing formula like this in the second column, if the number of employees is less that 10, then write 4-9, if less than 50 then 10-49 etc and...

Hi all, Can someone please assist with providing the following formula to calculate how to max out the total cell, (Q13=16.3 on my worksheet) to 11.5 and then subtract the Q13 difference from the cell that says 8.8 (P12 on my worksheet) This an attempt to calculate the difference in labor for...

Good afternoon all, Looking for some help on the below. Basically i am trying to get the cell to be blank if there is no date in another coloum. It works fine, but if the cell above it is also blank it displays #value. The dates change accoarding to month and therefore i want to keep the...

Hi,I am trying to use IF formula to show whether a row of cells matches: <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> Dog Dog Dog Fish Near Match Dog Dog Fish Fish Partial Match Cat Pig Fish Dog No Match Pig Pig Pig...

I'm sure for all of you its easy but I don't know how to simplify this formula: =IF('Personal Details'!AB58="female waxing", 'Personal Details'!B58, IF('Personal Details'!AB59="female waxing", 'Personal Details'!B59, IF('Personal Details'!AB60="Female Waxing", 'Personal Details'!B60,IF('Personal...