Hi im hoping someone can help.
This is what i need to happen.
If the cell in column W2 contains the letter s then the value in cell Z2 needs to change to show SP
I cant work this out because i have a formula in Z2 already.
Hi im hoping someone can help.
This is what i need to happen.
If the cell in column W2 contains the letter s then the value in cell Z2 needs to change to show SP
I cant work this out because i have a formula in Z2 already.
Last edited by valks1; 11-19-2020 at 04:18 PM.
your workbook is password protected.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Password Connell1
this looks like it should work for you...
=IF(W2="s","SP",CEILING.MATH(X2,Y2))
Thank you Sam.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks