Excel Formula please - comparing two fields.
Posted: Mon Oct 28, 2013 8:48 am
Hi.
I have an Excel sheet that I need to do some changes to help with a final figure.
So column B will either have (for example), Fred or Ginger in it. Column D will have some hours. Column E will have costs based on those hours.
I need in column F to check if B is "Fred" or "Ginger". And if it is either of those, to show what's in column E. If it's neither, it remains empty.
I've tried this:
=if(($B5="Fred"|"Ginger"), $E5))
But it doesn't like it. I use to be a real whiz with Excel, and did formulas that were amazing, but this was about 10+ years ago. Lost it all now.
I have an Excel sheet that I need to do some changes to help with a final figure.
So column B will either have (for example), Fred or Ginger in it. Column D will have some hours. Column E will have costs based on those hours.
I need in column F to check if B is "Fred" or "Ginger". And if it is either of those, to show what's in column E. If it's neither, it remains empty.
I've tried this:
=if(($B5="Fred"|"Ginger"), $E5))
But it doesn't like it. I use to be a real whiz with Excel, and did formulas that were amazing, but this was about 10+ years ago. Lost it all now.