Multiple If statements,

		Microsoft Office Forums > Microsoft Excel > Excel
Multiple If statements,

FAQ

Mark Forums Read

Thread Tools

Display Modes

07-29-2013, 02:08 AM

Pecoflyer

Windows 7 64bit Multiple If statements,

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Much better !
Enter

Code:

=IF(A3>0,A3+SIGN(B3)*B3,IF(B3>0,2*A3-B3,3*B3-A3))

in C3 and pull down as needed

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Please tell me it doesn't take 7 statements to turn table borders off	Jennifer Murphy	Word VBA	5	07-25-2012 03:12 PM
showing results of If statements in a mail merge	m&co	Mail Merge	3	01-06-2012 07:27 PM
Multiple Input, Multiple Digital Signatures	Jeff	Word	0	01-04-2012 09:03 AM
Multiple task lists and multiple calendars	kballing	Outlook	0	01-18-2011 10:23 AM
IF statements that shifts to right.	kent	Excel	0	01-19-2006 02:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:11 AM.