Question

$F$9 is a mixed type cell reference.(true / false)​

Answer 1

Answer:

true

Explanation:

NO NEED TO EXPLANATION

mark me brillieanst

and

thank to me

and

bhai itna thanks dena ki woh jo botten he na thanks dene se red ho ta he

itna dena ki green woh jae

almost 1k

and

mark me brillieanst

and

follow to me

and

vote to 5 star

Answer 2

True

YOUR QUESTION :

$F$9 is a mixed type cell reference.(true / false)

YOUR ANSWER :

I am trying to use the formula below in a workbook, but keep getting the message "A value used in this formula is of the wrong data type". Can anyone help / advise please which data is wrong.=IF(AND($D$9="MEDIUM","HIGH"),MAX($F$9:$F9)+1,0)