Simon Lee
New Member
Hi there
I'm sure this is child's play but I need the formula for this instance:
In the Cell J1 I need the following to happen;
If the letter Y is present in Cell D1 then I need the numerical values in Cells E1, F1, G1 & H1 to be added and then appear in Cell J1.
If the letter N is present in Cell D1 then I need a Zero to appear in Cell J1.
Try as I might I can't find a similar example.
Help![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I'm sure this is child's play but I need the formula for this instance:
In the Cell J1 I need the following to happen;
If the letter Y is present in Cell D1 then I need the numerical values in Cells E1, F1, G1 & H1 to be added and then appear in Cell J1.
If the letter N is present in Cell D1 then I need a Zero to appear in Cell J1.
Try as I might I can't find a similar example.
Help