0
   

Excel Problem

 
 
engineer
 
  1  
Reply Tue 27 Jan, 2015 04:51 pm
@DaughterRuler,
Use =if(c5>0,"",D5-E5) instead
DaughterRuler
 
  1  
Reply Tue 3 Feb, 2015 10:24 am
@engineer,
How can I use an =if and OR function?
I have a formula =IF(C5="","",IF(D5-E5<0,"Expired",D5-E5))
I want it to also say, if there is a date in K5 leave cell C5 blank
I tried to put an OR after the 1st =if but it doesn't work
engineer
 
  1  
Reply Tue 3 Feb, 2015 10:28 am
@DaughterRuler,
Not exactly sure what you are trying to do, but if you want to leave the cell blank if either C5 or K5 is empty, you could use

= IF( OR (C5="", K5="") , "" , IF(D5-E5<0,"Expired",D5-E5))
DaughterRuler
 
  1  
Reply Tue 3 Feb, 2015 12:12 pm
@engineer,
In cell F5 I want to say
if c5 is blank leave it blank, or if cell k5 has a date in it, leave it blank, if not do the rest of the formula

What it is, is Cell c5 is a date
D5 is =IF(C5="","",C5+30)
E5 is Today()
F5 is =IF(C5="","",IF(D5-E5<0,"Expired",D5-E5))

Sometimes I put a date in cell K5
If I put a date in K5 I don't want F5 to say Expired, I want it to either be blank or maybe say Received
engineer
 
  1  
Reply Tue 3 Feb, 2015 01:57 pm
@DaughterRuler,
IF(OR(C5="",K5<>""),"",IF(D5-E5<0,"Expired",D5-E5))
DaughterRuler
 
  1  
Reply Tue 3 Feb, 2015 02:29 pm
@engineer,
Nope, doesn't work ... it leaves it blank if there is nothing in K5 or a date like 2/2/14.
engineer
 
  1  
Reply Tue 3 Feb, 2015 02:53 pm
@DaughterRuler,
Try

IF(OR(C5="",K5>0),"",IF(D5-E5<0,"Expired",D5-E5))
DaughterRuler
 
  1  
Reply Tue 3 Feb, 2015 03:15 pm
@engineer,
Nope, doesn't work, same result! I've tried and tried ...
It's still blank - I copied and pasted just to make sure I'm not messing up!
engineer
 
  1  
Reply Tue 3 Feb, 2015 06:15 pm
@DaughterRuler,
I opened Excel and used this. It seems to do what I think you want.

=IF(OR(C5=0,K5>0),"",IF(D5-E5<0,"Expired",D5-E5))
DaughterRuler
 
  1  
Reply Wed 4 Feb, 2015 08:40 am
@engineer,
Yessssssssssss You're the best!
0 Replies
 
 

Related Topics

 
  1. Forums
  2. » Excel Problem
  3. » Page 2
Copyright © 2021 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 10/19/2021 at 03:35:22