Home | Community | Message Board


This site includes paid links. Please support our sponsors.


Welcome to the Shroomery Message Board! You are experiencing a small sample of what the site has to offer. Please login or register to post messages and view our exclusive members-only content. You'll gain access to additional forums, file attachments, board customizations, encrypted private messages, and much more!

Jump to first unread post Pages: 1
Invisibledemiu5
humans, lol
 User Gallery

Registered: 08/18/05
Posts: 43,948
Loc: the popcorn stadium Flag
Microsoft Works Spreadsheet, Logical algorithms (If, Then)
    #21698189 - 05/19/15 12:13 PM (8 years, 8 months ago)

I'm running into a problem making a template using the "If"/"Then" algorithm in Microsoft Works Spreadsheet (Win 7).  As well as using multiple values

If H(?)=T, Then, I=G(?)*1.08


for example, H27=T, G27=19.99*1.08

(if H27 = T, I27=G27*1.08)


is there anyway to accomplish this with this program?  I've tried it both using the f(x) wizard and free-hand, with no success.  i'm trying to implement an easy formula for tax/CRV charges


any help would be appreciated


--------------------
channel your inner Larry David


Extras: Filter Print Post Top
Invisiblekoraks
Registered: 06/02/03
Posts: 26,672
Re: Microsoft Works Spreadsheet, Logical algorithms (If, Then) [Re: demiu5]
    #21698230 - 05/19/15 12:29 PM (8 years, 8 months ago)

Code:
=if(H27="T",I27=G27*1.08,"")


This should work.

Syntax:
if(condition, value if true, value if false)
If you leave out the false value, it returns FALSE in the cell.


Extras: Filter Print Post Top
Invisibledemiu5
humans, lol
 User Gallery

Registered: 08/18/05
Posts: 43,948
Loc: the popcorn stadium Flag
Re: Microsoft Works Spreadsheet, Logical algorithms (If, Then) [Re: koraks]
    #21748700 - 06/01/15 02:11 PM (8 years, 7 months ago)

thanks, i'll give it a try

:thumbup:


--------------------
channel your inner Larry David


Extras: Filter Print Post Top
Jump to top Pages: 1


Similar ThreadsPosterViewsRepliesLast post
* Microsoft's Really Hidden Files. Lana 7,924 18 07/11/02 02:14 PM
by Lana
* Microsoft Issues Patch for 'Critical' Windows Secu Mojo_Risin 1,150 4 11/21/02 06:44 PM
by Mojo_Risin
* Microsoft Word security flaw BuzzDoctor 1,739 9 10/19/02 11:48 AM
by Purple_Voyage
* Any Excel experts around? I just need to merge two spreadsheets Lana 835 6 10/26/06 01:22 PM
by Lana
* generating words based on a template OJK 625 3 01/04/05 04:22 PM
by ummikko
* web based spreadsheet frith 271 1 01/20/10 08:09 AM
by abetterlie
* Microsoft Offers $250,000 Reward daussaulit 1,129 6 03/01/04 11:08 AM
by Trippytroll
* How do holograms work? Baby_Hitler 1,384 4 08/06/03 01:00 PM
by Edame

Extra information
You cannot start new topics / You cannot reply to topics
HTML is disabled / BBCode is enabled
Moderator: trendal, automan, Northerner
416 topic views. 0 members, 0 guests and 0 web crawlers are browsing this forum.
[ Show Images Only | Sort by Score | Print Topic ]
Search this thread:

Copyright 1997-2024 Mind Media. Some rights reserved.

Generated in 0.026 seconds spending 0.007 seconds on 14 queries.