AgTalk Home
AgTalk Home
Search Forums | Classifieds (137) | Skins | Language
You are logged in as a guest. ( logon | register )

Excel formula setup
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
Roger416
Posted 1/7/2024 19:33 (#10562387 - in reply to #10561979)
Subject: RE: Excel formula setup


Function IF is what you need.

For row 3 you must write on cell L1 the following:

=IF(K1-J1=G1+H1;K1-J1;"ERROR")

or if you like instead result of K1-J1 you can write the result of G1+H1:

=IF(K1-J1=G1+H1;G1+H1;"ERROR")

if comparison doesn't match you get the word ERROR

Edited by Roger416 1/8/2024 04:30
Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)