Hi all. thought I'd up a workbook
I'm trying to see if any cell in a column L6:L40 on sheet back! and sheet backa! contains any monetary value ($200 example in 5 cells maybe or just one cell) and If it does I want the words "you need to bank today" in another cell somewhere on the sheet appear if the cells are empty nothing to appear.
I hope that I have explained it clearly
Thanks for any and all help
StephenW
SOLVED here is the answer if anyone else may need it..........
Place this formula in e42
=COUNTIF(L5:L40,">=0")+COUNTIF(Back1a!L5:L40,">=0")
and this one in e43
=IF(E42>0,"How much did you bank today?","")
If any cell contains a number L5:L40 it will count how many times the cells are not empty but that does'nt matter as long as if one is full it will display the words " How much did you bank today "
thanks for looking
Bookmarks