If Formula

A

ADE2

Hi

I have a formula in cell Y11 shown below

=IF(ISERR(FIND("/",T1)),WORKDAY(Y10,6-WEEKDAY(Y10)),Y10-WEEKDAY(Y10,2)+8)

I need add a new condition to this formula so that it only operate
when the word DAILY appears in cell X10

X10 can have two values DAILY or 5 MIN

if X10 shows 5 MIN then i want to use a new formula in cell Y11

=IF(X10="5 MIN",BB3)

How can i combine these



Many thank
 
F

Frank Kabel

Hi
try
=IF(X10="Daily",IF(ISERR(FIND("/",T1)),WORKDAY(Y10,6-WEEKDAY(Y10)),Y10-
WEEKDAY(Y10,2)+8),"")
 
P

Pete JM

=IF(X10="
MIN",BB3,IF(ISERR(FIND("/",T1)),WORKDAY(Y10,6-WEEKDAY(Y10)),Y10-WEEKDAY(Y10,2)+8))

This will check to see if X10 ids equal to "5 MIN" if not it will d
the other formula
 
Top