If function question

[Patricktaylorbird]

Hi Folks,

Apologies if this is an idiot question but I’m struggling with a spreadsheet.

Some context:

I have a staff schedule/rota for a retail store in excel.

I have a second spreadsheet that calculates wages. I would like the wages spreadsheet to be populated by the schedule/rota.

We’re using one of the following fields holidays/sick/off. A worked shift is blank.

I would like my wages sheet to see each day of a week and either populate with the original content content (i.e holiday or sick or off) or if it’s blank to populate with a specific number of my choosing.

I understand an IF function will almost certainly do what iMm after but i’m Really struggling to understand how to make it work.

Any help would be hugely appreciated.

Patrick

 

[Truiz]

Would need to take a look at some sample data "if it’s blank to populate with a specific number of my choosing." --> Might need a Macro solution for it. but still need sample data