218499/return-blank-cell-referred-cell-blank-return-aging-entered

Try this:

=IF(ISBLANK(AC2),"",TODAY()-AC2)

The TODAY function automatically refreshes based on the time on your computer. Change TODAY() to a cell reference where a specific date is supplied to have control over the reference point that the calculation uses (and where it can be changed to suit).

You can enter the following formula in ...READ MORE

The IF function to calculate B5 (amount ...READ MORE

Actually, Excel is quite accommodating in this ...READ MORE

Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE

Try this formula in cell W4: =IF(V3=V4,INDEX(INDIRECT("I"&MATCH(W3,I:I,0)+1&":I26"),MATCH(V4,INDIRECT("R"&MATCH(W3,I:I,0)+1&":R26"),0)),INDEX($I$2:$I$26,MATCH(V4,$R$2:$R$26,0))) The calculation ...READ MORE

Try this: =IF(OR(A3-FLOOR(A3,1)>0.95,A3=CEILING(A3,1)),CEILING ...READ MORE

You may accomplish this by using two ...READ MORE

Use this: =IF(SUMPRODUCT(--(LEFT(G3,1)={"1","2","3"}))>0,"998", ...READ MORE

Here's how to accomplish things in another ...READ MORE

You could use IIf() DestSheet.Cells(erow, 9).Value = IIf(newuplift = ...READ MORE

OR

At least 1 upper-case and 1 lower-case letter

Minimum 8 characters and Maximum 50 characters

Already have an account? Sign in.