answer according to the spreadsheet.....if the valie of cell A1 and B1 is 2 and 3 respectively, what will be the value of C1 of formula =$A1*2+3*$B$1 is entered in the cell C1
Answers
Answered by
0
In cell D2 we will enter our IF AND formula as follows: ...... I am using conditional formatting with formula =$B2<TODAY() to .... A1 = 689 B1 =vlookup( A1,C1:E3,3,True) This displays the 600 total
Similar questions