If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula
I'm in need of a formula in C1 that gives me the value of A1 divided into
60 if B1 is empty, however if B1 has a value (not zero) then C1=B1/60. THANKS. |
#2
|
|||
|
|||
Formula
Hi,
This also checks they aren't both empty =IF(COUNT(A1:B1)=0,"",IF(B10,B1/60,A1/60)) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Trainee" wrote: I'm in need of a formula in C1 that gives me the value of A1 divided into 60 if B1 is empty, however if B1 has a value (not zero) then C1=B1/60. THANKS. |
#3
|
|||
|
|||
Formula
=IF(B1="",A1/60,IF(B10,B1/60,"B1 is =0"))
Gord Dibben MS Excel MVP On Sun, 6 Jun 2010 08:36:31 -0700, Trainee wrote: I'm in need of a formula in C1 that gives me the value of A1 divided into 60 if B1 is empty, however if B1 has a value (not zero) then C1=B1/60. THANKS. |
#4
|
|||
|
|||
Formula
THANK YOU! good formula Mike H. "Mike H" wrote: Hi, This also checks they aren't both empty =IF(COUNT(A1:B1)=0,"",IF(B10,B1/60,A1/60)) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Trainee" wrote: I'm in need of a formula in C1 that gives me the value of A1 divided into 60 if B1 is empty, however if B1 has a value (not zero) then C1=B1/60. THANKS. |
#5
|
|||
|
|||
Formula
your welcome
-- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Trainee" wrote: THANK YOU! good formula Mike H. "Mike H" wrote: Hi, This also checks they aren't both empty =IF(COUNT(A1:B1)=0,"",IF(B10,B1/60,A1/60)) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Trainee" wrote: I'm in need of a formula in C1 that gives me the value of A1 divided into 60 if B1 is empty, however if B1 has a value (not zero) then C1=B1/60. THANKS. |
Thread Tools | |
Display Modes | |
|
|