• We've upgraded our forums. Please post any issues/requests in this thread.

Excel question

Joined
Apr 4, 2009
Messages
529 (0.17/day)
Likes
20
Processor i3-4160
Motherboard msi z97 pcmate
Cooling generic
Memory 8gb ballistix
Video Card(s) evga 750 ti ftw
Storage samsung ssd 120gb + 1tb samsung
Case 210 elite
Power Supply evga 500w
Software Win 7 ultimate 64bit
#1
Looking at the break-even, can you show me the formula to make it so that the break-even will appear only once in year 2013 and for year 2014 and 2015 it would be blank or say something like "already break-even"...

Many thanks :)

http://www.techpowerup.org/uploaded.php?file=110215/excel060.png

btw, techpowerup.org copyright says 2005-20010 :)
 

W1zzard

Administrator
Staff member
Joined
May 14, 2004
Messages
17,026 (3.43/day)
Likes
17,890
Processor Core i7-4790K
Memory 16 GB
Video Card(s) GTX 1080
Display(s) 30" 2560x1600 + 19" 1280x1024
Software Windows 7
#2
use =IF()
 
Joined
Apr 4, 2009
Messages
529 (0.17/day)
Likes
20
Processor i3-4160
Motherboard msi z97 pcmate
Cooling generic
Memory 8gb ballistix
Video Card(s) evga 750 ti ftw
Storage samsung ssd 120gb + 1tb samsung
Case 210 elite
Power Supply evga 500w
Software Win 7 ultimate 64bit
#4
well yea if you look at my formula i used the if function. My question is after i enter the if function in B35 and I drag it all the way to F35, how do I make it so that break-even only appear in D13 and not E13 or F13 (or may be display something else in there?)
 
Joined
Sep 1, 2010
Messages
5,893 (2.22/day)
Likes
6,553
#5
if you want to use drag then use this

=if(or(b35="breakeven",b35="already breakeven"),"already breakeven")
 
Joined
Apr 4, 2009
Messages
529 (0.17/day)
Likes
20
Processor i3-4160
Motherboard msi z97 pcmate
Cooling generic
Memory 8gb ballistix
Video Card(s) evga 750 ti ftw
Storage samsung ssd 120gb + 1tb samsung
Case 210 elite
Power Supply evga 500w
Software Win 7 ultimate 64bit
#6
didnt work for me :(
 
Joined
Apr 4, 2009
Messages
529 (0.17/day)
Likes
20
Processor i3-4160
Motherboard msi z97 pcmate
Cooling generic
Memory 8gb ballistix
Video Card(s) evga 750 ti ftw
Storage samsung ssd 120gb + 1tb samsung
Case 210 elite
Power Supply evga 500w
Software Win 7 ultimate 64bit
#8
the function first need to compare b33 and b34 then it will give break-even or not. if it's breakeven then the years after that (even after dragged) need to be either blank or say sth like "already breakeven"

thanks :)
 
Joined
Dec 2, 2009
Messages
3,257 (1.11/day)
Likes
315
System Name Mercury KM-81
Processor Phenom II x4 B50
Motherboard ASUS M4A89GTD PRO
Cooling Cooler Master Hyper TX3
Memory 6GB Ram (4GBx1 Corsair 2GBx1 Nanya)
Video Card(s) PowerColor AX6770 V2.0
Storage 2TB WD Black, 1TB Hitachi, 500 GB WD Blue
Display(s) Philips 247E-LPH 24" 1920x1080
Case Mercury
Audio Device(s) Integrated Realtek
Power Supply Corsair 750TX
Software Windows 7 64-bit
Benchmark Scores Maybe it is time to benchmark :D
#9
Congrats w1zzard on your new avatar :)
 
Joined
Sep 1, 2010
Messages
5,893 (2.22/day)
Likes
6,553
#10
the function first need to compare b33 and b34 then it will give break-even or not. if it's breakeven then the years after that (even after dragged) need to be either blank or say sth like "already breakeven"

thanks :)
performing such a chore in excel is very annoying, if you want you can attach your excel file and I will write a program that will do and save all the calculations in that excel file
 
Joined
Apr 4, 2009
Messages
529 (0.17/day)
Likes
20
Processor i3-4160
Motherboard msi z97 pcmate
Cooling generic
Memory 8gb ballistix
Video Card(s) evga 750 ti ftw
Storage samsung ssd 120gb + 1tb samsung
Case 210 elite
Power Supply evga 500w
Software Win 7 ultimate 64bit
#11
can anyone show me how make it so that a long excel page would print correctly without cut offs ? :)

edit-figured it out :p i could slap myself for being so impatient
 
Last edited: