If and Elseif with Date comparison

excelos

Active Member
Joined
Sep 25, 2011
Messages
310
Hello,

Can you tell me please a formula for the following:

if the date in cell A1 is earlier than the date in cell B1, fill the formula cell with zero
elseif, fill the cell with a number

Can you advise me please?

Thanks!
 

r1998

Board Regular
Joined
Sep 9, 2018
Messages
106
Hello excelos and welcome to the forum :)
<b1,0,randbetween(1,100))[ code]<b1,0,randbetween(1,100))[="" code]
<b1,0,randbetween(1,100))[ code]
<b1,0,randbetween(1,100))[ code]

</b1,0,randbetween(1,100))[></b1,0,randbetween(1,100))[></b1,0,randbetween(1,100))[>
 
Last edited:

Forum statistics

Threads
1,085,843
Messages
5,386,297
Members
401,992
Latest member
CleverHopper

Some videos you may like

This Week's Hot Topics

Top